Re: Doing backups and restores from slaves

2003-10-06 Thread Jeremy Zawodny
On Mon, Oct 06, 2003 at 12:43:37PM -0700, David L. Sifry wrote: > An update to the problem, and a workaround (bug report?): > > Jeremy Zawodny wrote: > > >While the tables are locked, be sure to also copy the slave's > >master.info file, relay log(s), and relay index file. Transfer all of > >tha

Re: Doing backups and restores from slaves

2003-10-06 Thread David L. Sifry
An update to the problem, and a workaround (bug report?): Jeremy Zawodny wrote: While the tables are locked, be sure to also copy the slave's master.info file, relay log(s), and relay index file. Transfer all of that to the other slave and you should be good to go. Does that make sense? Actu

Re: Doing backups and restores from slaves

2003-10-06 Thread Jeremy Zawodny
On Sun, Oct 05, 2003 at 11:55:03PM -0700, David L. Sifry wrote: > I've got a somewhat advanced mysql administration question for y'all. > Here's my situation: > > I've got a master database that is doing lots of inserts, deletes, and > updates. It has a number of slaves hanging off of it. One

Doing backups and restores from slaves

2003-10-05 Thread David L. Sifry
I've got a somewhat advanced mysql administration question for y'all. Here's my situation: I've got a master database that is doing lots of inserts, deletes, and updates. It has a number of slaves hanging off of it. One of those slaves is completely unloaded - so it keeps very close track of