清理备份mysql bin文件

来源：互联网发布：excel数据生成折线图编辑：程序博客网时间：2024/05/16 12:53

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