- PURGE {MASTER | BINARY} LOGS TO 'log_name'
- PURGE {MASTER | BINARY} LOGS BEFORE 'date'
- PURGE MASTER LOGS TO 'MySQL-bin.010';
- PURGE MASTER LOGS BEFORE '2008-06-22 13:00:00';
- PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);
- PURGE {MASTER | BINARY} LOGS TO 'log_name'
- PURGE {MASTER | BINARY} LOGS BEFORE 'date'
- PURGE MASTER LOGS TO 'MySQL-bin.010';
- PURGE MASTER LOGS BEFORE '2008-06-22 13:00:00';
- PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);
上一篇:MYSQL日志文件维护
归档日志:bin-log。删库恢复的解决方案!主从复制的解决方案!
Mysql主从复制
Reset master; --清空所有的bin-log日志
...
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M