On Sun, May 24, 2009 at 06:50:52PM -0400, Dan Langille wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > John Drescher wrote: > >>> So, if you run backups locally to an external disk, you could back up the > >>> catalog by taking an ascii dump of the database, and copying the dump file > >>> to the same disk used for actual backup data. > >> So Can I just back the directory where the database is? > >> > > That is not a good way to backup a database. You need to run mysqldupm > > instead and backup the text file it generates. > > What John said. > > Not only does this ensure that your backup contains a valid MySQL dump, > it also exercises the database. That is, the act of running mysqldump > reads every part of the databases and dumps it out. If there is any > 'hidden' problem with the databases, chances are, you'll find out about > it during the dump process itself. > > Said explanation applies to all databases IMHO.
Thanks John and Dan for pointing out this for me. I will definetely do that. Zhengquan > > - -- > Dan Langille > > BSDCan - The Technical BSD Conference : http://www.bsdcan.org/ > PGCon - The PostgreSQL Conference: http://www.pgcon.org/ > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.11 (FreeBSD) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAkoZz0wACgkQCgsXFM/7nTxhwACffVigKxm386DGzYhGlxBkqIhv > 0usAoJnpJxahzI+T8sppKdJtG9g7J4fm > =lzRI > -----END PGP SIGNATURE----- -- Zhengquan ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://www.creativitycat.com _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
