RESET MASTER

You are viewing an old version of this article. View the current version here.
RESET MASTER [TO #]

Deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a new binary log file with a suffix of .000001.

If TO # is given, then the first new binary log file will start from number #. TO # was added in MariaDB 10.1.6

This statement is for use only when the master is started for the first time, and should never be used if any slaves are actively replicating from the binary log.

See also

The statement PURGE BINARY LOGS is intended for use in active replication.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.