Difference between revisions of "User:Sven"

From Organic Design wiki
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

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


Example Article

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