[Mediawiki-l] backup of a live wiki

[Dave Yost]

Here's how I backup a live wiki.

Before each backup:

#!/bin/zsh
mysql/support-files/mysql.server stop
{
   rsync -a --delete mysql/data mysql-snapshot-data
} always {
   mysql/support-files/mysql.server start
}

Back up mysql-snapshot-data.

Don't bother to back up mysql/data.  If you do backup mysql/data, 
never restore from it.

Also, see:
http://bugs.mysql.com/bug.php?id=21309

Dave