5. Open an new session and SSH into the slave server.
6. Connect to mysql with the following command:

mysql -u root -u

7. Enter in your mysql root password when prompted.
8. On the mysql prompt run the following command:

Show Slave Status \G;

Look for the values in Master_Log_File and Read_Master_Log_Pos. They should correspond to the File and Position noted above. If not, they will need to be changed on the slave server. The steps to follow will demonstrate how to make the change.

9. Stop the slave.

Stop Slave;

10. Change Master_Log_Pos. Enter in the number noted above in the “111” value below.

Change Master to Master_Log_Pos = 111;

11. Change Master_Log_File. Make sure the mysql-bin matched what was noted above.

Stay Connected

About

We are here to help! You've come here because you need help. Look no further. We have put together some FAQ and Tutorials to assist you. If the help you need cannot be resolved with the content on this KB, please open a ticket.