Re: How to Fix Broken Replication

2004-06-15 Thread Egor Egorov
"Henry Chang" <[EMAIL PROTECTED]> wrote: > > I have MySQL replication setup between Master A and Slave B. > Everything was working fine, until one day replication was broken. > Status on the slave shows the following error message: > > Last_error: Error 'Can't drop database X. Database doesn

RE: How to Fix Broken Replication

2004-06-14 Thread Henry Chang
John...the skip-counter is perfect!! My Slave B is now back up and running again. Thanks again for your prompt help!! *** REPLY SEPARATOR *** On 6/14/2004 at 3:54 PM John McCaskey wrote: >Give the below a shot: > >slave stop; >set global sql_slave_skip_counter=1; >slave start

RE: How to Fix Broken Replication

2004-06-14 Thread John McCaskey
Give the below a shot: slave stop; set global sql_slave_skip_counter=1; slave start; Good luck. John A. McCaskey -Original Message- From: Henry Chang [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 3:34 PM To: [EMAIL PROTECTED] Subject: How to Fix Broken Replication I have MyS