Re: Can I purge binlog files after migration ?

[Herrick Peterson]

Yes, you can purge binary logs on the test server after confirming they are no longer needed for replication or point-in-time recovery.

However, a normal mysqldump restore shouldn't normally result in 445 GB of binlogs unless binary logging is enabled on the destination and the restore is generating that much logged activity.

Since the original server reports 1381 and you don't have binary logging configured there, I would first check the test server with:

SHOW VARIABLES LIKE 'log_bin';
SHOW BINARY LOGS;

Also check the test server's my.cnf and any replication configuration. If log_bin is enabled and the binlogs are not required, you can purge them with:

PURGE BINARY LOGS BEFORE 'YYYY-MM-DD HH:MM:SS';

I would avoid manually deleting the binlog.000xxx files from the filesystem.

Please let me know if this has helped you

herrick, Devops Engineer @accuweb.cloud