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)