MyISAM Table maintenance

myisamchk — MyISAM Table-Maintenance Utility

by
MySQL Cluster

The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). The use of myisamchk with partitioned tables is not supported.   How to run this Utility – myisamchk  myisamchk [options] tbl_name The options specify … Read more

Recovering Corrupt Tables : MyISAM Table Crash Recovery

by
MySQL Cluster

If you have to restore MyISAM tables that have become corrupt, try to recover them using REPAIR TABLE  or myisamchk -r That should work in 99.9% of all cases. In this article we will cover to repair/recover MyISAM tables using myisamchk. MyISAM tables have .MYD and .MYI  files for storing data and indexes. You can use … Read more