Alan Brown wrote: > On Tue, 5 Feb 2008, John Drescher wrote: > >>> @echo off >>> xcopy /y /q /k C:\MySQL\data\bacula E:\backup\bacula-database\ >>> exit >>> >> Isn't there a mysqldump for windows? I do not think this is a good way >> of backing up a database that is in use. > > It isn't. > > mysqlhotcopy can be used to copy out the tables in binary format if that's > really wanted, but my experience is that the mysqldump table compresses > _extremely_ well on tape.
I prefer and advocated dumping databases to text files if practical. I prefer to know that I have a text backup of my data rather than a binary backup of my data. -- Dan Langille - http://www.langille.org/ BSDCan - The Technical BSD Conference: http://www.bsdcan.org/ PGCon - The PostgreSQL Conference: http://www.pgcon.org/ ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
