[mythtv-users] Backing up mysql database.
Brad DerManouelian
myth at dermanouelian.com
Wed Sep 5 14:49:12 UTC 2007
On Sep 5, 2007, at 7:25 AM, Mike Perkins wrote:
> Brad DerManouelian wrote:
>>
>> 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.
>>
> Good luck inspecting that ~20Mb text file...
>
> Mike Perkins
Thanks! I have had good luck. I do it all the time. vi is my friend.
It also helps to have a good handle on the database structure that
mythtv uses. Oh, and mine's around 76M as of this morning:
[mythtv at mythtv2 backup]$ du -h mythdatabase.20070905.bak
76M mythdatabase.20070905.bak
More information about the mythtv-users
mailing list