-1

After disabling log-bin by skip-log-bin option, I cannot use PURGE command to remove binary logs.

Refer to the documentation

PURGE BINARY LOGS requires the BINLOG_ADMIN privilege. This statement has no effect if the server was not started with the --log-bin option to enable binary logging.

My question is: If I need reenable log-bin in the future, is it safe to delete remaining binary logs with rm binlog.* command now?

shingo
  • 99
  • 2

1 Answers1

0

No, you should not delete them by hand, it isn't safe.

If you can't use PURGE to remove binary logs, consider using binlog_expire_logs_seconds which will remove automatically the binary log files after their expiration period ends.

Ergest Basha
  • 5,369
  • 3
  • 7
  • 22