修改mysql 配置文件,移动mysql数据存储位置修改。
重启mysql的时候,mysql日志也会抛错错误
2021-11-27T00:34:43.403963Z 0 [ERROR] Failed to open log (file '/logs/mysql-bin.000001', errno 2) 2021-11-27T00:34:43.403982Z 0 [ERROR] Could not open log file mysqld: File '/logs/mysql-bin.000002' not found (Errcode: 2 - No such file or directory) 2021-11-27T00:34:43.404675Z 0 [ERROR] Failed to open log (file '/logs/mysql-bin.000002', errno 2) 2021-11-27T00:34:43.404866Z 0 [ERROR] Could not open log file mysqld: File '/logs/mysql-bin.000003' not found (Errcode: 2 - No such file or directory) 2021-11-27T00:34:43.405652Z 0 [ERROR] Failed to open log (file '/logs/mysql-bin.000003', errno 2)
打开mysql-bin.index,删除mysql-bin.000001、mysql-bin.000002、mysql-bin.000003三条记录
[root@mysql57 logs]# cat mysql-bin.index /logs/mysql-bin.000004 /logs/mysql-bin.000005 /logs/mysql-bin.000006 /logs/mysql-bin.000007 /logs/mysql-bin.000008 /logs/mysql-bin.000009 /logs/mysql-bin.000010 /logs/mysql-bin.000011 /logs/mysql-bin.000012 /logs/mysql-bin.000013
重启mysql,则显示正常
标签:logs,抛错,file,mysql,日志,open,27T00,log From: https://www.cnblogs.com/xzlive/p/16981471.html