Difference between revisions of "User:Sven"

From Organic Design wiki
m (→‎Contact details)
m (→‎Apache in OS X (tiger))
Line 53: Line 53:
 
There are  differences as to the locations of installed directories from standard binary/source linux installations. Its worth
 
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'''
 
checking the build with the terminal command '''httpd -V'''
−
  <table class=document-code><tr><td>[[+httpd -V]]</td></tr></table>
+
  <table class=document-code><tr><td>[[+Sven/OS X/httpd -V]]</td></tr></table>
  
 
The webpage is accessable as localhost or 127.0.0.1, with access to your personal home page at:
 
The webpage is accessable as localhost or 127.0.0.1, with access to your personal home page at:

Revision as of 00:41, 30 January 2006

User: Sven

My Wiki Userpages
Bookmarks


Books
Finance

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

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

Retrieved from "https://organicdesign.nz/wiki/index.php?title=User:Sven&oldid=8702"