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