[mythtv-users] Backing up mysql database.
Michael T. Dean
mtdean at thirdcontact.com
Wed Sep 5 06:44:40 UTC 2007
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."
More information about the mythtv-users