Re: [Slashcode-general] MySQL backups?

[Jamie M. <ja...@mc...>]

=46or best results, set up replication to a slave DB that is used for
nothing but backups, and mysqldump from that.  That way it doesn't
matter how long you lock tables.  Once the backup is done and the
locks are freed, replication will just pick up where it left off
(and will catch up pretty quickly to be ready for your next
mysqldump).

You can even do this all on the same machine, with two instances of
mysqld, if you want (assuming it has enough RAM and disk bandwidth).
--=20
  Jamie McCarthy
 http://mccarthy.vg/
  ja...@mc...