Use this to check and to repair MyISAM
tables, as well as to optimize them. This utility is similar in use
and purpose to
myisamchk. Instead of working with
the table files directly like
this utility interacts with the MySQL server instead. It uses the
ANALYZE TABLE, the
The name of the database containing the tables to check is given as the second argument to the utility. The table to check is given as the third argument. Additional tables may be given in a space-separated list. Here is a list of options that you can give and a brief explanation of each:
Instructs the utility to check all databases.
Instructs the utility to execute all queries for all tables in each database in one statement rather than in separate queries for each table.
Has the utility analyze tables.
Instructs the utility to automatically repair any corrupted tables found.
Specifies the directory containing character sets.
Instructs the utility to check tables for errors.
Has the utility check only tables that have changed since the last check, as well as tables that were not closed properly.
Instructs the utility to compress data passed between it and the server if supported.
Specifies more than one database for checking. ...