RESET Syntax

The RESET statement is used to clear the state of various server operations. You must have the RELOAD privilege to execute RESET.

RESET acts as a stronger version of the FLUSH statement. See , "FLUSH Syntax".

reset_option can be any of the following:

• 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.

• QUERY CACHE

  Removes all query results from the query cache.

• SLAVE

  Makes the slave forget its replication position in the master binary logs. Also resets the relay log by deleting any existing relay log files and beginning a new one.

Retornar