[解决] 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. 1. service mysql stop
   
2. 
   
3. 2. cd /var/lib/mysql/databasename
   
4. 
   
5. 3. myisamchk -r tablename
   
6. MyISAM-table 'tablename' is not fixed because of errors
   
7. Try fixing it by using the --safe-recover (-o), the --force (-f)
   
8. option or by not using the --quick (-q) flag
   
9. 
   
10. 4. myisamchk -r -o -f tablename 如果第三step不行，跑这行
    
11. Data records: 107435
    
12. Found block that points outside data file at 16166832
    
13. 
    
14. 5. service mysql start

复制代码