[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