MAN page from Trustix mysql-client-3.23.58-3tr.i586.rpm
isamchk
Section: MySQL database (1)
Updated: 19 December 2000
Index NAME
isamchk - Description, check and repair of ISAM tables.Used without options all tables on the command will be checked for errors
USAGE
isamchk [OPTIONS] tables[.ISM]
SYNOPSIS
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]
DESCRIPTION
- -a|--analyze
- Analyze distribution of keys. Will make some joins inMySQL 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 thisonly in extreme cases as isamchk should normally findall errors even without this switch
- -f|--force
- Overwrite old temporary files.If one uses -f when checking tables (running isamchkwithout -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. Normallyisamchk repairs the table a symlink points at.
- -q|--quick
- Used with -r to get a faster repair. (The data fileisn't touched.) One can give a second '-q' to forceisamchk to modify the original datafile.
- -r|--recover
- Can fix almost anything except unique keys that aren'tunique.
- -o|--safe-recover
- Uses old recovery method; slower than '-r' but canhandle 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 isamchkvery silent
- -S|--sort-index
- Sort index blocks. This speeds up 'read-next' inapplications
- -R|--sort-records=#
- Sort records according to an index. This makes yourdata 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 ALSO
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),
AUTHOR
Ver 1.0, distribution 3.23.29aMichael (Monty) Widenius (montyAATTtcx.se),TCX Datakonsult AB (
http://www.tcx.se).This software comes with no warranty.Manual page by L. (Kill-9) Pedersen (kill-9AATTkill-9.dk), Mercurmedia Data Model Architect /system developer (
http://www.mercurmedia.com)
Index
- NAME
- USAGE
- SYNOPSIS
- DESCRIPTION
- SEE ALSO
- AUTHOR
This document was created byman2html,using the manual pages.
