isamchk and myisamchk

These utilities allow you to check and repair damaged tables, display table information, perform index key value distribution analysis, and disable or enable indexes. Chapter 4, "Query Optimization," provides more information on key analysis and index disabling. Chapter 13, "Database Maintenance and Repair," provides more information on table checking and repair.

myisamchk is used for tables that use the newer MyISAM storage format. These tables have data and index filenames with .MYD and .MYI suffixes. Use isamchk for tables that use the older ISAM storage format. These have data and index filenames with .ISD and .ISM suffixes. If you tell either utility to operate on a table of the wrong type, it will print a warning ...

Get MySQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.