Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Subscribe to our newsletter

Advertise on LowEndTalk.com

In this Discussion

MySQL: Slave SQL Thread not running
New on LowEndTalk? Please read our 'Community Rules' by clicking on it in the right menu!

MySQL: Slave SQL Thread not running

kcajkcaj Member

Any ideas?

Comments

  • SysAdminSysAdmin Administrator

    Are you running master / master or master / slave?

  • kcajkcaj Member

    SysAdmin said: 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.

  • SysAdminSysAdmin Administrator

    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;

Sign In or Register to comment.