[mythtv-users] Locking Mysql database for backup
bitjunkie at gmail.com
Fri Nov 12 17:57:52 UTC 2004
> 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
> Any ideas?
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.
More information about the mythtv-users