Removing Mysql Binary logs

Posted 4 years ago - updated 4 years ago mysql

Remove all up to filename

PURGE BINARY LOGS TO 'mysql-bin.000285'

Remove files more than 3 days old

PURGE BINARY LOGS BEFORE DATE(NOW() - INTERVAL 3 DAY) + INTERVAL 0 SECOND

Updating

 Live

mysql> SET GLOBAL expire_logs_days = 3;

Config

[mysqld]
expire-logs-days=3