[mythtv-users] Is locking tables important when backing up mythconverg?

[Tony Lill]

David Campbell <dave at cpfc.org> writes:

> Yeechang Lee wrote:
>>     --set-charset
>> 
>> --lock-tables is what causes the fleeting frontend freezeup. Some
>> quick experimenting with running my script with the addition of
>> --skip-lock-tables verifies this.
>> 
>> So, what am I risking here, if anything, by backing up the system with
>> --skip-lock-tables? Even as a database dunce I know enough about the
>> concept of table locking to ensure data integrity, but does it really
>> matter for what is fundamentally a single-user (mythbackend) database?
>> 
>
> You risk having an inconsistent backup of the database if inserts or 
> updates are occurring during the backup.
>
> How risky it is depends on how valuable the data is and how often it 
> gets updated.
>
> Mysqldump isn't really designed to be run in this fashion.  If you need 
> backups every two hours I'd consider using hotbackups as it's faster 
> (although still locks)
>
> mysqlhotcopy --addtodest -u mysqluser -p somepass mythconverg /backupdir
>
> or using mysql replication to have a standy database somewhere.
>
> Dave
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Why not turn on binary logs, if you've turned them off. That way you
can recover up to the minute, unless you loose the disk with the
logs. Then you can do the full backups in off hours. That's how I run.

I don't remember if you said why you were doing the backups,
protecting against hardware stupidity or application stupidity.
--
Tony Lill,                         Tony.Lill at AJLC.Waterloo.ON.CA
President, A. J. Lill Consultants        fax/data (519) 650 3571
539 Grand Valley Dr., Cambridge, Ont. N3H 2S2     (519) 241 2461
--------------- http://www.ajlc.waterloo.on.ca/ ----------------

Understatement of the century:
"Hello everybody out there using minix - I'm doing a (free) operating
 system (just a hobby, won't be big and professional like gnu) for
 386(486) AT clones"

	- Linus Torvalds, August 1991