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`
环境
- ubuntu 20
- mysql 8
处理
service mysql stop
cd /var/lib/mysql/$DATABASE
#尝试
myisamchk -r $TABLE
#失败时执行
myisamchk -r -v -f $table
service mysql start