How To Check and Repair MyISAM Tables in MySQL?

If you have a corrupted MyISAM table, like the one resulted from the previous tutorial exercise, you can use the "CHECK TABLE" and "REPAIR TABLE" commands to try to repair it. The following tutorial exercise gives you a good example of repairing a corrupted MyISAM table. Luckily, the table is repaired successfully:

>\mysql\bin\mysql -u dev -piyf fyi

mysql> CHECK TABLE fyi_isam;
+--------------+-------+----------+-------------------------
| Table        | Op    | Msg_type | Msg_text                
+--------------+-------+----------+-------------------------
| fyi.fyi_isam | check | error    | Record at pos: 0 is not
                                       remove-marked
| fyi.fyi_isam | check | error    | record delete-link-chain
                                       corrupted
| fyi.fyi_isam | check | error    | Corrupt                 
+--------------+-------+----------+-------------------------
3 rows in set (0.01 sec)

mysql> REPAIR TABLE fyi_isam;
+--------------+--------+----------+------------------------
| Table        | Op     | Msg_type | Msg_text               
+--------------+--------+----------+------------------------
| fyi.fyi_isam | repair | warning  | Number of rows changed
                                        from 1 to 2
| fyi.fyi_isam | repair | status   | OK                     
+--------------+--------+----------+------------------------
2 rows in set (0.47 sec)

mysql> SELECT * FROM fyi_isam;
+----+-------+-------+
| id | title | count |
+----+-------+-------+
| -1 | NULL  |  NULL |
| -2 | NULL  |   987 |
+----+-------+-------+
2 rows in set (0.00 sec)

⇒ Tables Using InnoDB Storage Engine in MySQL

⇐ Restore Tables by Copying MyISAM Files in MySQL

⇑ Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇑⇑ MySQL Database Tutorials