-----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. - -- 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----- ------------------------------------------------------------------------------ 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
