On Mon, Jun 20, 2005 at 01:57:56PM +0100, Dave Howorth wrote: > This is just a fact of life, true for any backup system. It depends what > guarantees of integrity you need and what table types you're using. I > use InnoDB and want error-free backups so I just send '/etc/init.d/mysql > stop' as my 'pre-client' command and '/etc/init.d/mysql start' > afterwards. For high availability systems where you don't want to stop mysql, use the LVM to take a snapshot of the database partition. Just flush the mysql tables (flush tables with read lock), take the snapshot then unlock the tables. Now, you can back up the snapshot at your leisure without worrying about an inconsistent database. -- Dave Carrigan Seattle, WA, USA dave@rudedog.org | http://www.rudedog.org/ | ICQ:161669680 UNIX-Apache-Perl-Linux-Firewalls-LDAP-C-C++-DNS-PalmOS-PostgreSQL-MySQL
Attachment:
signature.asc
Description: Digital signature