Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book