清理备份mysql bin文件

1. 首先备份mysql 的bin文件

2. 登陆mysql 执行purge命令，清理mysql bin日志， 注意保留当前正在使用的日志

mysql> show binary logs;
+------------------+------------+
| Log_name         | File_size  |
+------------------+------------+
| mysql-bin.000001 |      27786 |
| mysql-bin.000002 |     995784 |
| mysql-bin.000003 |        264 |
| mysql-bin.000004 |   60553729 |
| mysql-bin.000005 |   11840510 |
| mysql-bin.000006 | 1073742090 |
| mysql-bin.000007 | 1073742202 |
| mysql-bin.000008 | 1073742015 |
| mysql-bin.000009 | 1073742019 |
| mysql-bin.000010 |  989292908 |
+------------------+------------+
10 rows in set (0.03 sec)


mysql> purge binary logs to 'mysql-bin.000009';
Query OK, 0 rows affected (2.51 sec)


mysql> show binary logs;
+------------------+------------+
| Log_name         | File_size  |
+------------------+------------+
| mysql-bin.000009 | 1073742019 |
| mysql-bin.000010 |  989534235 |
+------------------+------------+
2 rows in set (0.00 sec)


mysql> purge binary logs to 'mysql-bin.000010';
Query OK, 0 rows affected (0.78 sec)


mysql> show binary logs;
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000010 | 990197560 |
+------------------+-----------+
1 row in set (0.00 sec)


mysql> exit
Bye