This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

If you see these types of error messages from MySQL database:#

Database failed to execute query (query) 1016: Can't open file: 'sometable.MYI'. (errno: 145)

Error Msg: 1034: Incorrect key file for table: 'sometable'. 

You can check and repair the table from a mysql prompt as follows: (mysql prompt is available from your DB admin tool within Plesk – phpmyAdmin)

check table sometable;

+------------------+-------+----------+----------------------------+

| Table | Op | Msg_type | Msg_text | 

+------------------+-------+----------+----------------------------+ 

| yourdb.sometable | check | warning | Table is marked as crashed | 

| yourdb.sometable | check | status | OK | 

+------------------+-------+----------+----------------------------+ 

repair table sometable;


+------------------+--------+----------+----------+ 

| Table | Op | Msg_type | Msg_text | 

+------------------+--------+----------+----------+ 

| yourdb.sometable | repair | status | OK | 

+------------------+--------+----------+----------+

Your table should now be fine