Difference between revisions of "User:Sven"
(dont want create table in mysqldump) |
|||
| Line 41: | Line 41: | ||
location so the information is not lost then use mysql to reconstruct wikidb. | location so the information is not lost then use mysql to reconstruct wikidb. | ||
| − | *mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql | + | *<s>mysqldump -u root -p --single-transaction wikidb > /tmp/backup.sql</s> creates tables which already exist |
| + | *mysqldump -u root -p --single-transaction --no-create-info wikidb > /tmp/backup.sql | ||
*wikipath=`locate wikidb | grep wikidb$` | *wikipath=`locate wikidb | grep wikidb$` | ||
*sudo mv $wikipath ${wikipath}-bak | *sudo mv $wikipath ${wikipath}-bak | ||
Revision as of 23:04, 21 November 2005
Making articles foo and fodda (again) to see search engine side effects. New Article Sven/Thesis
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 (OS X)
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.sqlcreates 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
- mysql -u root -p
- create database wikidb
- use wikidb
- source backup.sql
- # Check the directory sizes match between wikidb and wikidb-bak
- sudo du $wikipath
- sudo du $wikipath-bak
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>
|



