How to repair crashed tables in MySQL if auto repair fails

Here is what you should do if a table crashes and auto repair after mysql restart fails. Open a terminal / command line utility If crash is on remote server you will need to ssh first service mysql stop cd /var/lib/mysql/{your database name} myisamchk -r {table name} – recovering (with sort) MyISAM-table ‘{table name}’ Data records: ...