[mythtv-users] Locking Mysql database for backup

[Joel Anderson]

> 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