User:Sven

---

My Wiki Userpages

• Wikipedia/Zven
• Mediawiki/Zven
• WikiMedia/Zven

Bookmarks

Wikipedia

• Help:Content
• Help:Editing
• Wikipedia templates

MediaWiki

• MediaWiki extensions
• Category:MediaWiki
• FAQ
• Variables
• Users Guide

Customizing

• Hooks and their parameters
• LocalSettings.php
• DefaultSettings.php
• MediaWiki Architecture
• MediaWiki tools
• Python Wikipedia bot

InterWiki

• WikiMedia Interwiki map
• Wikipedia Interwiki map

Books

Finance

• Exchange rates
• ASB rates

---

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 as 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

+Sven/OS X/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

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

If an error occurs in a redirect then nothing is inserted after the statement that causes the error (e.g. primary keys already exist), whereas interactively from the command line invalid INSERT's provide a warning only and valid statements are still restored. This is because the bash redirect is being used to stream the file line by line, exiting at the point of failure. Introduced into mysqldump in version 5.0.15 is --insert-ignore which allows dumps of INSERT IGNORE statements. In this case a command line redirect whould work if the dump was;

• mysqldump -u root -p --single-transaction --no-create-info --insert-ignore wikidb > /tmp/backup.sql

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 -D wikidb < /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

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.

---

Contact details

• Name: Marcus Davy
• Address: 27/3 Raumati Road
  Remuera
  Auckland 1309
• Email: MDavy@hortresearch.co.nz
  mdavy86@gmail.com
• Phone: 5202 751
  815 8859 (work DDI)
  021 500 103 (suz's cell)