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