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 [EMAIL PROTECTED] | http://www.rudedog.org/ | ICQ:161669680 UNIX-Apache-Perl-Linux-Firewalls-LDAP-C-C++-DNS-PalmOS-PostgreSQL-MySQL
signature.asc
Description: Digital signature
