(mysql.info.gz) RESET SLAVE

Info Catalog

(mysql.info.gz) MASTER_POS_WAIT

(mysql.info.gz) Replication Slave SQL

(mysql.info.gz) SET GLOBAL SQL_SLAVE_SKIP_COUNTER

 
 13.6.2.5 `RESET SLAVE' Syntax
 .............................
 
      RESET SLAVE
 
 Makes the slave forget its replication position in the master's binary
 logs.  This statement is meant to be used for a clean start: It deletes
 the `master.info' and `relay-log.info' files, all the relay logs, and
 starts a new relay log.
 
 * All relay logs are deleted, even if they have not been totally
 executed by the slave SQL thread.  (This is a condition likely to exist
 on a replication slave if you have issued a `STOP SLAVE' statement or
 if the slave is highly loaded.)
 
 Connection information stored in the `master.info' file is immediately
 reset using any values specified in the corresponding startup options.
 This information includes values such as master host, master port,
 master user, and master password.  If the slave SQL thread was in the
 middle of replicating temporary tables when it was stopped, and `RESET
 SLAVE' is issued, these replicated temporary tables are deleted on the
 slave.
 
 This statement was named `FLUSH SLAVE' before MySQL 3.23.26.
 

Info Catalog

(mysql.info.gz) MASTER_POS_WAIT

(mysql.info.gz) Replication Slave SQL

(mysql.info.gz) SET GLOBAL SQL_SLAVE_SKIP_COUNTER