[mythtv-users] Backing up mysql database.

Brad DerManouelian 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  
> up?
> -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...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070904/35c7b7e3/attachment.htm 


More information about the mythtv-users mailing list