MySQL MYI Table Errors


Quary
MySQL ‘MYI’ Table Errors

Error Messages From MySQL Database
Database failed to execute query (query) 1016: Can’t open file: ‘conntrack.MYI’.(errno: 145)
Error Msg: 1034: Incorrect key file for table: ‘sometable’.

Check & Repair Table From MySQL
check table conntrack;
+——————+——-+———-+—————————-+
| Table | Op | Msg_type | Msg_text |
+——————+——-+———-+—————————-+
| yourdb.conntrack | check | warning | Table is marked as crashed |
| yourdb.conntrack | check | status | OK |
+——————+——-+———-+—————————-+

Repair Conntrack Table
repair table conntrack;
+——————+——–+———-+———-+
| Table | Op | Msg_type | Msg_text |
+——————+——–+———-+———-+
| yourdb.conntrack | repair | status | OK |
+——————+——–+———-+———-+

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s