DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) RESET

Info Catalog (mysql.info.gz) LOAD INDEX (mysql.info.gz) Other administrative SQL
 
 13.5.5.5 `RESET' Syntax
 .......................
 
      RESET RESET_OPTION [, RESET_OPTION] ...
 
 The `RESET' statement is used to clear the state of various server
 operations. It also acts as a stronger version of the `FLUSH'
 statement.   `FLUSH' FLUSH.
 
 To execute `RESET', you must have the `RELOAD' privilege.
 
 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. Previously named `FLUSH MASTER'.   Replication Master
      SQL.
 
 `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. Previously named `FLUSH
      SLAVE'.   Replication Slave SQL.
 
 
Info Catalog (mysql.info.gz) LOAD INDEX (mysql.info.gz) Other administrative SQL
automatically generated byinfo2html