Am Thu, 11 Feb 2010 07:08:28 -0500 schrieb Dan Langille: > JanJaap Scholing wrote: >> Thanks for all the input. >> >> I think a lvm snapshot is the best way to go for us. > > Be aware of the potential risks of backing up a database at the file > system level. What you may be backing up is a database in an > inconsistent state (e.g. part way through a transaction). When you use > mysqldump, you do not encounter this situation.
one could run "FLUSH TABLES WITH READ LOCK" (and not close the connection) to write everything to disk and then take the snapshot. howto: http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup- and-replication-setup/ ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
