[mythtv-users] Locking Mysql database for backup

Ryan mythtv at frouse3.homelinux.com
Fri Nov 12 18:10:16 UTC 2004

Thanks I'll look into that.

>> Does anyone know offhand how to lock a mysql database for backup? I'd
>> like
>> to cron a table dump, but I would like to lock the database before doing
>> so.
>> Any ideas?
>> thanks
>> Ryan
>> http://frouse3.homelinux.com/
> I use the mysqlhotcopy script in a cron job, works well and takes care
> of the table locks and all that.  You can also use mysqldump, I
> believe it does as well.
> HTH,
> --
> Joel



More information about the mythtv-users mailing list