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

Latest LowEndBox Offers

    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

    J1021J1021 Member

    Any ideas?

    Comments

    • SysAdminSysAdmin Administrator

      Are you running master / master or master / slave?

    • J1021J1021 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.