User:Sven

Making articles foo and fodda (again) to see search engine side effects. New Article Sven/Thesis

Installing MediaWiki on OS X

Media wiki requires:

1. Apache webserver
2. PHP
3. 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

• Apache for OS X
• PHP for Apache shipped with OS X

---

Example Article

Backing up wikidb using mysql (OS X)

Information for doing this came from here. There are many ways to go about this;

• drop entire databases, and reconstruct
• drop tables if they exist for a particular database and reconstruct tables and data
• Insert data only into databases (errors can be introduced if not using INSERT IGNORE statements)

Caveat: When using restore on INSERT statements only where tables already exist, there are two ways to restore

1. mysql> source backup.sql #(interactively inside mysql itself)
2. mysql -u root -D wikidb < backup.sql #(bash call using a redirect)

If an error occurs in a redirect then nothing is inserted (e.g. primary keys already exist), wheras interactively from the command line valid inserts are still restored

Here I want to move the wikidb directory in mysql to a temporary location (say /tmp directory) so the information is not perminantly lost then use mysql to reconstruct wikidb.

• mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql creates 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
• [Time to recreate MediWiki which will make the wikidb database]
• mysql -u root -p wikidb
• create database wikidb
• use wikidb
• source /tmp/backup.sql
• # Check the directory sizes match between wikidb and wikidb-bak
• sudo du $wikipath
• sudo du $wikipath-bak
• # Refresh the links using maintenance script
• php refreshLinks.php

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>

NOTE: You can be real casual with table syntax and miss out all </tr>'s and </td>'s if you like.