Tuesday, July 31, 2012

mysql: recover from sql replication error

if you encounter a replication error caused by one sql command, you can skip that error and continue your replication by running the following commands on your slave:

mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; 
mysql> start slave;

No comments:

Post a Comment

SSH : No matching host key type found. Their offer: ssh-rsa,ssh-dss

Got this while connecting to my mikrotik router via ssh   Unable to negotiate with <ip address> port <ssh port>: no matching hos...