Name
RESET MASTER
Synopsis
RESET MASTER
This statement deletes all the binary log files on the master server. Binary log files
are located in the directory indicated by the value of the
--log-bin
option of mysqld
(see Chapter 15). The log files are typically
named log-bin.n
, where
n
is a six-digit numbering index. Use the
SHOW MASTER LOGS statement to get a list of log files to be sure.
This statement will delete all of the master log files and begin
numbering the new file at 000001. To get the slave servers in line
with the reset master, run the RESET SLAVE
statement. You can run the MASTER
and
SLAVE
options together in a comma-separated list
like so:
RESET MASTER, SLAVE;
This is a recommended method for ensuring consistency.
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.