diff options
Diffstat (limited to 'man/isamchk.1.in')
| -rw-r--r-- | man/isamchk.1.in | 145 |
1 files changed, 145 insertions, 0 deletions
diff --git a/man/isamchk.1.in b/man/isamchk.1.in new file mode 100644 index 00000000000..cad1303ee55 --- /dev/null +++ b/man/isamchk.1.in @@ -0,0 +1,145 @@ +.TH isamchk 1 "19 December 2000" "MySQL @MYSQL_BASE_VERSION@" "MySQL database" +.SH NAME +.BR isamchk + \- Description, check and repair of ISAM tables. +Used without options all tables on the command will be checked for errors +.SH USAGE +isamchk [OPTIONS] tables[.ISM] +.SH SYNOPSIS +.B isamchk +.RB [ \-a | \-\-analyze ] +.RB [ \-# | \-\-debug=... ] +.RB [ \-\-character\-sets\-dir=...] +.RB [ \-C | \-\-default\-character\-set=...] +.RB [ \-d | \-\-description ] +.RB [ \-e | \-\-extend\-check ] +.RB [ \-f | \-\-force ] +.RB [ \-? | \-\-help ] +.RB [ \-i | \-\-information ] +.RB [ \-k | \-\-keys\-used=# ] +.RB [ \-l | \-\-no\-symlinks] +.RB [ \-q | \-\-quick ] +.RB [ \-r | \-\-recover ] +.RB [ \-o | \-\-safe\-recover ] +.RB [ \-O | "\-\-set\-variable var=option"] +.RB [ \-s | \-\-silent ] +.RB [ \-S | \-\-sort\-index ] +.RB [ \-R | \-\-sort\-records=#] +.RB [ \-u | \-\-unpack ] +.RB [ \-v | \-\-verbose ] +.RB [ \-V | \-\-version ] +.RB [ \-w | \-\-wait ] +.SH DESCRIPTION +.TP +.BR \-a | \-\-analyze +Analyze distribution of keys. Will make some joins in +MySQL faster. +.TP +.BR \-# | \-\-debug=... +Output debug log. Often this is 'd:t:o ,filename` +.TP +.BR \-\-character\-sets\-dir=... +Directory where character sets are +.TP +.BR \-C | \-\-default\-character\-set=... +Set the default character set +.TP +.BR \-d | \-\-description +Prints some information about table. +.TP +.BR \-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 +.TP +.BR \-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. +.TP +.BR \-? | \-\-help +Display help and exit. +.TP +.BR \-i | \-\-information +Print statistics information about the table +.TP +.BR \-k | \-\-keys\-used=# +Used with '\-r'. Tell ISAM to update only the first +# keys. This can be used to get faster inserts! +.TP +.BR \-l | \-\-no\-symlinks +Do not follow symbolic links when repairing. Normally +isamchk repairs the table a symlink points at. +.TP +.BR \-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. +.TP +.BR \-r | \-\-recover +Can fix almost anything except unique keys that aren't +unique. +.TP +.BR \-o | \-\-safe\-recover +Uses old recovery method; slower than '\-r' but can +handle a couple of cases that '\-r' cannot handle. +.TP +.BR \-O | " \-\-set\-variable var=option " +Change the value of a variable. +.TP +.BR \-s | \-\-silent +Only print errors. One can use two \-s to make isamchk +very silent +.TP +.BR \-S | \-\-sort\-index +Sort index blocks. This speeds up 'read\-next' in +applications +.TP +.BR \-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!) +.TP +.BR \-u | \-\-unpack +Unpack file packed with pack_isam. +.TP +.BR \-v | \-\-verbose +Print more information. This can be used with +\-d and \-e. Use many \-v for more verbosity! +.TP +.BR \-V | \-\-version +Print version and exit. +.TP +.BR \-w | \-\-wait +Wait if table is locked. +.SH "SEE ALSO" +isamlog(1), +mysql(1), +mysqlaccess(1), +mysqladmin(1), +mysqld(1), +mysqld_multi(1), +mysqld_safe(1), +mysqldump(1), +mysql_fix_privilege_tables(1), +mysqlshow(1), +mysql_zap(1), +perror(1), +replace(1) +.P +For more information please refer to the MySQL reference +manual, which may already be installed locally and which +is also available online at http://www.mysql.com/doc/en/ +.SH BUGS +Please refer to http://bugs.mysql.com/ to report bugs. +.SH AUTHOR +Ver 1.0, distribution @MYSQL_NO_DASH_VERSION@ +Michael (Monty) Widenius (monty@mysql.com), +MySQL AB (http://www.mysql.com/). +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) + +.\" end of man page |