标题: [解决] MySQL Table is marked as crashed and last (automatic?) repair failed [打印本页] 作者: 资讯王 时间: 2018-6-14 00:06 标题: [解决] MySQL Table is marked as crashed and last (automatic?) repair failed Ubuntu ERROR 144 - Table is marked as crashed and last (automatic?) repair failed
我是因为Server空间不足,导致table crashed
检查Table
mysqlcheck -u root -p -A
如何解决?ERROR 144 - Table is marked as crashed and last (automatic?) repair failed
1. service mysql stop
2. cd /var/lib/mysql/databasename
3. myisamchk -r tablename
MyISAM-table 'tablename' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f)
option or by not using the --quick (-q) flag
4. myisamchk -r -o -f tablename 如果第三step不行,跑这行
Data records: 107435
Found block that points outside data file at 16166832