New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
Are you running master / master or master / slave?
Master / Slave. Previously had this working okay but now trying to move the slave to a new host.
Look at the slave status, it's possible there has been an error such as a duplicate primary key which has stopped the process. If that's the case, you can skip the error and start the process again:
STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
START SLAVE;
SHOW SLAVE STATUS \G;