On Thu, 24 Apr 2008 09:27:23 +1200 Roger Searle <[EMAIL PROTECTED]> wrote: [snip]
Must admit that I use cron and a shellscript for these kind of databases...
$MySQLDump -u user -ppassword --quick --no_create_info --disable-keys
--extended-insert --single-transaction database > ${ArchiveDir}/database.sql
( I also have a separate one to download the empty schema, and gzip the dump as
a separate process if necessary - it does use a lot of cpu ).
I do this because a lot of the built-in backup procedures are written by people
who don't really understand how to make a proper snapshot of the database, and
you can easily end up with tables out of step with each other: it's quicker to
extend existing scripts than wade through their code.
And I may well be maligning mediawiki unfairly, as is always possible when
making sweeping generalizations like this.
Steve
pgpC89Fu86S4I.pgp
Description: PGP signature
