Re: Restarting slave after interruption

2008-05-24 Thread François Beausoleil
Thanks Mike! Le 2008-05-22 à 17:13, Mike a écrit : If your taking a dump of the master open two windows. Don't close either In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; & master status; Then in the second window procedure with mysqldump. The exact syntax was FLUSH

Re: Restarting slave after interruption

2008-05-24 Thread Moon's Father
This is a classic error. You just reconfigurate the parameter master_log_file and master_log_pos .Good luck. On Fri, May 23, 2008 at 5:13 AM, Mike <[EMAIL PROTECTED]> wrote: > On Thu, May 22, 2008 at 10:41 AM, François Beausoleil < > [EMAIL PROTECTED]> > wrote: > > > Hi all! > > I must be stupid

Re: Restarting slave after interruption

2008-05-22 Thread Mike
On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <[EMAIL PROTECTED]> wrote: > Hi all! > I must be stupid or something. I can't find what my problem is. > > I searched this list, and did find a couple of hits, but nothing that > seemed fully relevant. This one in particular was interesting: