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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users