How To Repair MySQL(Master Slave) Replication

How To Repair MySQL(Master Slave) Replication

 

If Mysql replication is not working and we are getting very strange error. Here is solution to repair mysql replication.

 

Error:Untitled 1_html_5b13d627

To fix above error run below mysql queries:

 

mysql> STOP SLAVE;

 

It simply tell the slave skip invalid sql query.

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

 

mysql> STOP SLAVE;

 

.. and check if replication is working again:

Untitled 1_html_m19c608a1

 

 

 

Leave a comment

Your email address will not be published.


*