[mythtv-users] Backing up mysql database.

[Michael T. Dean]

On 09/05/2007 02:36 AM, Brad DerManouelian wrote:
> 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.

Such as creating new files for partial restores, i.e. for new hardware
or "spring cleaning."

http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7

Mike