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.

MariaDB starting with 10.1.6

If TO # is given, then the first new binary log file will start from number #.

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 loading...