How do I repair MyISAM tables in MySQL?

How do I repair MyISAM tables in MySQL?

First, try myisamchk -r -q tbl_name ( -r -q means “quick recovery mode”). This attempts to repair the index file without touching the data file. If the data file contains everything that it should and the delete links point at the correct locations within the data file, this should work, and the table is fixed.

 

dev.mysql.com/doc/refman/5.7/en/myisam-r...20table%20is%20fixed .