taken from:http://dev.mysql.com/doc/refman/5.1/en/rebuilding-tables.html So if you need to repair a table's index, the first thing to do is verify the storage engine for the table: SHOW CREATE TABLE tbl_name ALTER TABLE tbl_name ENGINE = eng_namemysql ( Read more... )