MySQL : 126 Incorrect Key File for Table MYI Try to Repair It
November 09 2014
You may could not get information from the table in MySQL database, need to check the table status by mysqlcheck.
# mysqlcheck mysql_linuxfaq
mysql_linuxfaq.id OK
mysql_linuxfaq.name OK
mysql_linuxfaq.address OK
mysql_linuxfaq.videos
Error : Incorrect information in file: './ mysql_linuxfaq.videos/videos.frm'
error : Corrupt
To repair a particular table, before doing that take a backup of table or Database
mysql> use mysql_database;
mysql> repair table videos;
+---------------------------------+--------+------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------+--------+------------+
| mysql_linuxfaq.videos | repair | status | OK |
+---------------------------------+--------+------------+
1 row in set (0.02 sec)
*Database name : mysql_linuxfaq
*table name : videos
Another option is use mysqlcheck command.
Comments (0)