How to Use myisamchk
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 ...
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
