[mythtv-users] Backing up mysql database.
myth at dermanouelian.com
Wed Sep 5 06:36:58 UTC 2007
On Sep 4, 2007, at 11:17 PM, Bill Williamson wrote:
> On 9/5/07, clemens at dwf.com <clemens at dwf.com> wrote:
> Is there any advantage in using one of the mysql backup programs over
> just taring up /var/lib/mysql/mysql and /var/lib/mysql/mythconverg ?
> -Are you completely shutting down the database before tarring those
> -Are you guaranteeing that you will be using the EXACT same version
> of MySQL if you need to do a restore?
> You should ignore the existance of ANY database raw files kept on a
> filesystem. Pretend they don't exist.
I also like that when I dump my database, it's human-readable so if I
ever need to restore, I can actually see at what point I'm restoring
and if I need to make any modifications before I restore, I can do
that by hand.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users