背景:
为清理空间,删除了所有的bin log
启动mysql报错,查看日志 /var/lib/mysql/mariadb.err
有报错:
2022-05-23 19:00:53 0 [ERROR] mysqld: File './mysql-bin.010228' not found (Errcode: 2 "No such file or directory")
2022-05-23 19:00:53 0 [ERROR] Failed to open log (file './mysql-bin.010228', errno 2)
2022-05-23 19:00:53 0 [ERROR] Could not open log file
解决:
将index文件删除(移到/tmp目录下)
启动mysql即成功。