[mythtv-users] Locking Mysql database for backup

[Kevin Kuphal]

Ryan wrote:

>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?
>  
>
read this:

http://dev.mysql.com/doc/mysql/en/Backup.html

And note the mysqldump program and the command-line options it has to 
LOCK the tables before they are dumped, specifically the 
--lock-all-tables option.

Kevin