[mythtv-users] Locking Mysql database for backup

[Ryan]

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
>


Ryan

Ryan