ubuntu Mysql table is marked as crashed | mysql 数据表修复

996
|
2022-10-09 10:46:13

问题:`Table 'posts' is marked as crashed and last (automatic?) repair failed`

环境

处理

service mysql stop

cd /var/lib/mysql/$DATABASE

#尝试
myisamchk -r $TABLE

#失败时执行
myisamchk -r -v -f $table

service mysql start