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't exist'
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't exist'
on query 'DROP DATABASE X.
I suspect
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
;
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 MySQL replication setup between Master A and Slave B.
Everything
was working fine, until one
