A-A+
#1194 – Table ‘user’ is marked as crashed and should be repaired
今天给mysql添加一字段的时候,突然电脑抽风死机了,无奈只能强制关机重启。当我重启之后,运行MySQL,user表竟然数据都没了,还提示错误如下:
#1194 - Table 'user' is marked as crashed and should be repaired
无奈啊,于是百度,发现是表损坏了。那么该如何修复解决呢?
在DOS下或phpmyadmin或者navicat等操作mysql的工具里面执行一下查询
REPAIR TABLE `user`;