MySQL Purge Binary Logs

From UNIX Systems Administration
Jump to navigation Jump to search
  1. Change to the directory containing the binary log files.
    1. Note the last time on the first to newest mysql-bin.######, use that time for the purge binary logs before command.
  2. Flush the logs.
    1. # mysqladmin flush-logs -p -uroot
  3. Login to MySQL.
    1. mysql -p -uroot
  4. Purge the binary logs.
    1. mysql> purge binary logs before 'yyyy-mm-dd hh:mm:ss' (note: the seconds is optional)

Further Reading

  1. MySQL Reference Guide - PURGE BINARY LOGS Syntax