How to repair a MySQL table of type MyISAM that could not be repaired.
* First STOP MYSQL
* cd into the data folder of your database where the table is crashed, by default :
cd /var/lib/mysql/NameOfDatabase
For me :
cd /var/lib/mysql/centstorage
* Run the myisamchk on the table
myisamchk -r NameOfTableCrashed
* If that does not work run :
myisamchk -r -v -f NameOfTableCrashed
For me (note the -t option which permits to specify where to use the temp folder, because this can take a lot of space. :
myisamchk -r log -t=/data/tmp/