Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Repair MyISAM Tables

By: FYIcenter.com

(Continued from previous topic...)

How To Check and Repair MyISAM Tables?

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)

(Continued on next topic...)

  1. What Are Storage Engines?
  2. How To Create a New Table Using MyISAM Storage Engine?
  3. Where Table Data Is Stored by the MyISAM Storage Engine?
  4. How To Backup Tables by Copying MyISAM Table Files?
  5. How To Restore Tables by Copying MyISAM Table Files?
  6. How To Check and Repair MyISAM Tables?
  7. How To Create a New Table Using the InnoDB Storage Engine?
  8. Where Table Data Is Stored by the InnoDB Storage Engine?
  9. How To Create a New Table Using the BDB Storage Engine?
  10. How To Start mysqld to Support the BDB Storage Engine?
  11. Where Table Data Is Stored by the BDB Storage Engine?
  12. How To Create a New Table Using the CSV Storage Engine?
  13. How To Create a New Table Using the MEMORY Storage Engine?
  14. What Happens to MEMORY Tables When MySQL Server Is Stopped?
  15. How To See Which Storage Engines Are Supported in Your MySQL Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...