December 2002
Beginner
640 pages
16h 41m
English
myisamchk has many modes in which it can be used. The following is its basic syntax:
myisamchk [options] table_name [table_name2 ...]
Or you can use wildcard characters on the names of the directories and files:
myisamchk [options] /path/to/mysql/data/*/*.MYI
Using the first syntax, you can run myisamchk on a single table, whereas the second syntax pattern enables you to run it on several tables at once, including across several databases.
You can run it with or without a number of options, whose meanings you will see in a moment.
To use the first syntax given previously—where you refer to a table by table_name—you must be in the data directory of the MySQL database you're working on. If you're not, myisamchk won't know ...