MySQL master-Slave synchronization Last_sql_error

Reference article:

http://kerry.blog.51cto.com/172631/277414/

http://hancang2010.blog.163.com/blog/static/18246026120107602018998/

During synchronization, a trigger statement was found to be incorrect, resulting in a subsequent synchronization statement not being performed.

Solution:

mysql > Stop slave;

MySQL > SET GLOBAL sql_slave_skip_counter = 1; # # (normally 1 is the safest, and may not be set in the case of Skip_error.)

mysql > Start slave; # #启动同步

MySQL > show slave status\g; Discover slave_sql_running_state:updating .... Description data is being updated

Additional notes:

Http://www.2cto.com/database/201108/100485.html

You can also set the following options in MY.CNF to automatically skip this error.
slave-skip-errors=1062