Tuesday, October 24, 2017

Purge [Remove] MySQL Replication old logs

Procedure: Below is command syntax for remove old replication log file.

PURGE BINARY LOGS Syntax
# PURGE { BINARY | MASTER } LOGS
    { TO 'log_name' | BEFORE datetime_expr }

Examples:
mysql> PURGE BINARY LOGS TO 'mysql-bin.011';

mysql> PURGE BINARY LOGS BEFORE '2017-08-01 22:46:26';


No comments:

Post a Comment