(mysql.info.gz) SET GLOBAL SQL_SLAVE_SKIP_COUNTER

Info Catalog

(mysql.info.gz) RESET SLAVE

(mysql.info.gz) Replication Slave SQL

(mysql.info.gz) SHOW SLAVE STATUS

 
 13.6.2.6 `SET GLOBAL SQL_SLAVE_SKIP_COUNTER' Syntax
 ...................................................
 
      SET GLOBAL SQL_SLAVE_SKIP_COUNTER = N
 
 Skip the next N events from the master. This is useful for recovering
 from replication stops caused by a statement.
 
 This statement is valid only when the slave thread is not running.
 Otherwise, it produces an error.
 
 Before MySQL 4.0, omit the `GLOBAL' keyword from the statement.
 

Info Catalog

(mysql.info.gz) RESET SLAVE

(mysql.info.gz) Replication Slave SQL

(mysql.info.gz) SHOW SLAVE STATUS