Difference between revisions of "User:Sven"
(mysql backup example of wikidb) |
(Adding byte checks) |
||
| Line 34: | Line 34: | ||
:[[Example Article]] | :[[Example Article]] | ||
| − | ==Backing up wikidb using mysql== | + | ==Backing up wikidb using mysql (OS X)== |
Information for doing this came from [http://meta.wikimedia.org/wiki/Backup_Database here]. | Information for doing this came from [http://meta.wikimedia.org/wiki/Backup_Database here]. | ||
The idea is to make a sql dump of the database, move the wikidb directory in mysql to a temporary | 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. | location so the information is not lost then use mysql to reconstruct wikidb. | ||
| + | *wikipath=`locate wikidb | grep wikidb$` | ||
| + | *sudo mv $wikipath ${wikipath}-bak | ||
*mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql | *mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql | ||
*cd /tmp | *cd /tmp | ||
| Line 45: | Line 47: | ||
*use wikidb | *use wikidb | ||
*source backup.sql | *source backup.sql | ||
| + | * <nowiki>#</nowiki> Check the directory sizes match between wikidb and wikidb-bak | ||
| + | * sudo du $wikipath | ||
| + | * sudo du $wikipath-bak | ||
| + | |||
== R programming language markup == | == R programming language markup == | ||
Revision as of 22:24, 21 November 2005
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.
- wikipath=`locate wikidb | grep wikidb$`
- sudo mv $wikipath ${wikipath}-bak
- mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql
- cd /tmp
- mysql -u root -p
- create database wikidb
- use wikidb
- source 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>
|
