Gavin Towey wrote:
What Shawn said is important.
Better options:
1. Use InnoDB, and then you can make a consistent backup with `mysqldump
--single-transaction > backup.sql` and keep your db server actively responding
to requests at the same time.
2. Use something like LVM to create filesytem snapshots which allow you to
backup your database, while only keeping a read lock on the db for a second or
so.
3. Set up replication and backup the replicated data using any of the
above method.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
