Skip navigation links
12.6.1.3 SET sql_log_bin Syntax »
Section Navigation      [Toggle]

12.6.1.2. RESET MASTER Syntax

RESET MASTER

Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. It is intended to be used only when the master is started for the first time.

Important

The effects of this statement differ from those of PURGE BINARY LOGS in 2 key ways:

  1. RESET MASTER removes all binary logs that are listed in the index file, leaving only a single, empty binary log file named master-bin.000001, whereas the numbering is not reset by PURGE BINARY LOGS.

  2. RESET MASTER is not intended to be used while any replication slaves are running. The behavior of RESET MASTER when used while slaves are running is undefined (and thus unsupported), whereas PURGE BINARY LOGS may be safely used while replication slaves are running.

See also Section 12.6.1.1, “PURGE BINARY LOGS Syntax”.

RESET MASTER can prove useful when you first set up the master and the slave, so that you can verify the setup as follows:

  1. Start the master and slave, and start replication (see Section 16.1.1, “How to Set Up Replication”)

  2. Execute a few test queries on the master

  3. Check that the queries were replicated to the slave

  4. When replication is running correctly, issue STOP SLAVE on the slave, followed by RESET SLAVE; verify that any unwanted data no longer exists on the slave

  5. Issue RESET MASTER on the master to clean up the test queries

After verifying the setup and getting rid of any unwanted and logs generated by testing, you can start the slave and begin replicating.