Difference between revisions of "User:Sven"
m |
(mysql backup example of wikidb) |
||
| Line 33: | Line 33: | ||
---- | ---- | ||
:[[Example Article]] | :[[Example Article]] | ||
| + | |||
| + | ==Backing up wikidb using mysql== | ||
| + | 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 | ||
| + | location so the information is not lost then use mysql to reconstruct wikidb. | ||
| + | |||
| + | *mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql | ||
| + | *cd /tmp | ||
| + | *mysql -u root -p | ||
| + | *create database wikidb | ||
| + | *use wikidb | ||
| + | *source backup.sql | ||
== R programming language markup == | == R programming language markup == | ||
Revision as of 22:15, 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
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.sql
- cd /tmp
- mysql -u root -p
- create database wikidb
- use wikidb
- source backup.sql
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>
|



