RE: Mysqlhotcopy and replication

2006-06-29 Thread Jeff McKeon
Excellent Dan! Thanks! -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Thu 6/29/2006 4:35 PM To: Jeff Cc: mysql@lists.mysql.com Subject: Re: Mysqlhotcopy and replication Jeff, that is

Re: Mysqlhotcopy and replication

2006-06-29 Thread Dan Buettner
Jeff, that is indeed the case - the replication thread will "freeze" just like any other thread, and pick up where it left off. In fact, the statements are still replicated to the slave by the replication thread, stored in the slave's relay-bin file I think. Therefore even though the slave data i

Mysqlhotcopy and replication

2006-06-29 Thread Jeff
I've got a replication slave db (all MyISAM tables) that I currently back up every night by stopping MySQL, tarballing the table files, then starting MySQL up again. I'd like to use Mysqlhotcopy to do this so that the db can stay up for reads while the backup is being done. Here's my question. W