ISAMCHK

isamchk − Description, check and repair of ISAM tables. Used without options all tables on the command will be checked for errors

isamchk [OPTIONS] tables[.ISM]

isamchk [−a|−−analyze] [−#|−−debug=...] [−−character−sets−dir=...] [−C|−−default−character−set=...] [−d|−−description] [−e|−−extend−check] [−f|−−force] [−?|−−help] [−i|−−information] [−k|−−keys−used=#] [−l|−−no−symlinks] [−q|−−quick] [−r|−−recover] [−o|−−safe−recover] [−O|−−set−variable var=option] [−s|−−silent] [−S|−−sort−index] [−R|−−sort−records=#] [−u|−−unpack] [−v|−−verbose] [−V|−−version] [−w|−−wait]

−a|−−analyze

Analyze distribution of keys. Will make some joins in MySQL faster.

−#|−−debug=...

Output debug log. Often this is ’d:t:o ,filename‘

−−character−sets−dir=...

Directory where character sets are

−C|−−default−character−set=...

Set the default character set

−d|−−description

Prints some information about table.

−e|−−extend−check

Check the table VERY thoroughly. One need use this only in extreme cases as isamchk should normally find all errors even without this switch

−f|−−force

Overwrite old temporary files. If one uses −f when checking tables (running isamchk without −r), isamchk will automatically restart with −r on any wrong table.

−?|−−help

Display help and exit.

−i|−−information

Print statistics information about the table

−k|−−keys−used=#

Used with ’−r’. Tell ISAM to update only the first # keys. This can be used to get faster inserts!

−l|−−no−symlinks

Do not follow symbolic links when repairing. Normally isamchk repairs the table a symlink points at.

−q|−−quick

Used with −r to get a faster repair. (The data file isn’t touched.) One can give a second ’−q’ to force isamchk to modify the original datafile.

−r|−−recover

Can fix almost anything except unique keys that aren’t unique.

−o|−−safe−recover

Uses old recovery method; slower than ’−r’ but can handle a couple of cases that ’−r’ cannot handle.

−O| −−set−variable var=option

Change the value of a variable.

−s|−−silent

Only print errors. One can use two −s to make isamchk very silent

−S|−−sort−index

Sort index blocks. This speeds up ’read−next’ in applications

−R|−−sort−records=#

Sort records according to an index. This makes your data much more localized and may speed up things (It may be VERY slow to do a sort the first time!)

−u|−−unpack

Unpack file packed with pack_isam.

−v|−−verbose

Print more information. This can be used with −d and −e. Use many −v for more verbosity!

−V|−−version

Print version and exit.

−w|−−wait

Wait if table is locked.

isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill−9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurmedia.com)