Difference between revisions of "User:Sven"
(dont want create table in mysqldump) |
|||
| Line 46: | Line 46: | ||
*sudo mv $wikipath ${wikipath}-bak | *sudo mv $wikipath ${wikipath}-bak | ||
*cd /tmp | *cd /tmp | ||
| − | *mysql -u root -p | + | *mysql -u root -p wikidb |
| − | *create database wikidb | + | *<s>create database wikidb</s> |
| − | *use wikidb | + | *<s>use wikidb</s> |
| − | *source backup.sql | + | *source /tmp/backup.sql |
* <nowiki>#</nowiki> Check the directory sizes match between wikidb and wikidb-bak | * <nowiki>#</nowiki> Check the directory sizes match between wikidb and wikidb-bak | ||
* sudo du $wikipath | * sudo du $wikipath | ||
Revision as of 23:12, 21 November 2005
Making articles foo and fodda (again) to see search engine side effects. New Article Sven/Thesis
Contents
Installing MediaWiki on OS X
Media wiki requires:
- Apache webserver
- PHP
- Mysql
See mediawiki.org and sourceforge for installation details. As OS X ships with a built in Apache webserver, installation of PHP, and Mysql is all that is required. If you want to run Apache aas a secure webserver then you probably have to build Apache from source.
PHP 5.0.4/4.3.11 is available as a dmg, and Mysql 4.1.13a is available A Mysql backup tool is also available from the apple website
Apache in OS X (tiger)
Apache/1.3.33 is shipped with a standard install of OS X on Jaguar, Panther, and Tiger. It does not come with php pre-compiled.
- Start your personal webserver under;
preferences → Sharing → Personal Web Sharing
There are differences as to the locations of installed directories from standard binary/source linux installations. Its worth checking the build with the terminal command httpd -V
| +httpd -V |
The webpage is accessable as localhost or 127.0.0.1, with access to your personal home page at:
- http://127.0.0.1/~USER_NAME
The webserver pages are located in the directories
- /Library/WebServer (System pages)
- /Users/USER_NAME/Sites (User page)
Useful Links
Backing up wikidb using mysql (OS X)
Information for doing this came from here. The idea is to make a sql dump of the database, move the wikidb directory in mysql to a temporary location so the information is not lost then use mysql to reconstruct wikidb.
mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sqlcreates tables which already exist- mysqldump -u root -p --single-transaction --no-create-info wikidb > /tmp/backup.sql
- wikipath=`locate wikidb | grep wikidb$`
- sudo mv $wikipath ${wikipath}-bak
- cd /tmp
- mysql -u root -p wikidb
create database wikidbuse wikidb- source /tmp/backup.sql
- # Check the directory sizes match between wikidb and wikidb-bak
- sudo du $wikipath
- sudo du $wikipath-bak
R programming language markup
| +CreateDirectories.R |
LaTeX document class letter markup
| +letter.tex |
xml Wiki Markup
Table Markup |
<table class=document-code><tr><td>Table Markup</td></tr></table>
|



