重启系统后mysql表损坏 Incorrect key file for table '.\axxxx.MYI'; try to repair it","tourl":"",.....
报错
重启服务器后发现MySQL无法写入数据,报错:
---------------------------------------------------------------------------- {"code":0,"data":"执行SQL发生错误!错误:Incorrect key file for table '.\/novel\/axxxx.MYI'; try to repair it","tourl":"","rowtotal":1} ---------------------------------------------------------------------------- ★[2022-10-20 13:41:02] Successful
修复
针对报错的表执行:
repair table 表名;
REPAIR TABLE 表名 USE_FRM;
测试恢复结果
insert插入一个试一下