MySQL Manual
4 Database Administration
4.5.4 RESET Syntax
RESET reset_option [,reset_option] ...
The RESET command is used to clear things. It also acts as an stronger
version of the FLUSH command. See section 4.5.3 FLUSH Syntax.
To execute RESET, you must have the RELOAD privilege.
| Option | Description |
MASTER | Deletes all binary logs listed in the index file, resetting the binlog
index file to be empty. Previously named FLUSH MASTER. See section 4.10.7 SQL Commands Related to Replication.
|
SLAVE | Makes the slave forget its replication position in the master
logs. Previously named FLUSH SLAVE. See section 4.10.7 SQL Commands Related to Replication.
|
QUERY CACHE | Removes all query results from the query cache. |
