大马资讯论坛 - 马来西亚中文资讯平台

 找回密码
 注册
搜索

[解决] MySQL Table is marked as crashed and last (automatic?) repair failed

[复制链接]
发表于 2018-6-14 00:06:49 | 显示全部楼层 |阅读模式
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. 1. service mysql stop

  2. 2. cd /var/lib/mysql/databasename

  3. 3. myisamchk -r tablename
  4. MyISAM-table 'tablename' is not fixed because of errors
  5. Try fixing it by using the --safe-recover (-o), the --force (-f)
  6. option or by not using the --quick (-q) flag

  7. 4. myisamchk -r -o -f tablename 如果第三step不行,跑这行
  8. Data records: 107435
  9. Found block that points outside data file at 16166832

  10. 5. service mysql start
复制代码

手机版|大马资讯论坛  

GMT+8, 2021-12-8 17:10 , Processed in 0.047137 second(s), 11 queries , File On.

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表