Name
RESET
Synopsis
RESET [QUERY CACHE|MASTER|SLAVE]
Use this statement to reset certain server settings and log
files. The RELOAD
privilege is required to use this
statement. The QUERY CACHE
option clears the
cache containing SQL query results.
Use the MASTER
option to reset a master
used for replication. This statement must be executed from the master
itself. It will start a new binary log file, as well as delete the
binary log file names from the index file and delete the contents of
the binary log index file. The SLAVE
option
is used to reset a slave used for replication and must
be executed from the slave itself. It will start a new relay log file
and delete any existing ones, as well as delete its notation of its
position in the master’s binary log. See Chapter 8 on replication for more information on
these two options.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.