isamchk(1) MySQL database isamchk(1)NAMEisamchk
- Description, check and repair of ISAM tables. Used
without options all tables on the command will be checked
for errors
USAGEisamchk [OPTIONS] tables[.ISM]
SYNOPSISisamchk [-a|--analyze] [-#|--debug=...] [--charac-
ter-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]
DESCRIPTION
-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), isam-
chk 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. Nor-
mally 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.
SEE ALSOisamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1),
mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1),
msql2mysql (1), perror (1), replace (1), mysqld_safe (1),
which1 (1), zap (1),
AUTHOR
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.mercurme-
dia.com)
MySQL 4.0 19 December 2000 isamchk(1)
