[mythtv-users] Really nice MySQL backup script

Andrew Davis andrew at nccomp.com
Wed Sep 13 21:57:25 UTC 2006


Nope... its specifically meant to be used on an active DB. It locks the 
tables and all transactions are queued. Once complete, it unlocks the 
tables, then the queue is played against the DB. In my experience, I can 
backup 20Gb DB's in less than 30 minutes with good disk I/O.

File is attached...

Boleslaw Ciesielski wrote:
> Andrew Davis wrote:
>> FYI: mysqldump is not a very restorable solution for active databases 
>> as the tables aren't locked during a backup. mysqlhotcopy is much 
>> better. Check out the script I use on my production mysql servers...
>
> Thank you for sharing, but your mailer wrapped the lines. Can you 
> resend it as an attachment?
>
> Also, if the script locks the database then does it mean that mythtv 
> may hang, potentially screwing up the recording in progress?
>
> Thanks,
>
> Bolek
>
>
>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysqlhotcopy_script.txt
Url: http://mythtv.org/pipermail/mythtv-users/attachments/20060913/d43129d0/attachment-0001.txt 


More information about the mythtv-users mailing list