Seth Woolley's Man Viewer

isamchk(1) - .BR isamchk - Description, check and repair of ISAM tables. Used without options all tables on the command will be checked for errors - man 1 isamchk

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

isamchk(1)                      MySQL database                      isamchk(1)

        -  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]

              Analyze distribution of keys. Will  make  some  joins  in(1,8)  MySQL

              Output debug log. Often this is 'd:t:o ,filename`

              Directory where character sets are

              Set the default character set(7,n,1 builtins)

              Prints some information about table.

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

              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.

              Display help and exit.

              Print statistics information about the table

              Used with '-r'. Tell ISAM to update(7,n) only the first # keys.  This
              can be used to get faster inserts!

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

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

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

              Uses old recovery method; slower than '-r' but can handle a cou-
              ple of cases that '-r' cannot handle.

       -O| --set-variable var=option
              Change the value of a variable.

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

              Sort index blocks.  This speeds up 'read-next' in(1,8) applications

              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(1,3) the first time(1,2,n)!)

              Unpack file(1,n) packed with pack_isam.

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

              Print version(1,3,5) and exit.

              Wait if(3,n) table is locked.

       isamlog(1),   mysql(1),   mysqlaccess(1),   mysqladmin(1),   mysqld(1),
       mysqld_multi(1),    mysqld_safe(1),    mysqldump(1),   mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1,3)(1), replace(1)

       For more information please refer to the MySQL reference manual,  which
       may  already be installed locally and which is also available online at

       Please refer to to report bugs.

       Ver    1.0,    distribution    4.0.21    Michael    (Monty)    Widenius
       (,  MySQL  AB  (   This software
       comes  with  no  warranty.   Manual  page  by  L.   (Kill-9)   Pedersen
       (, Mercurmedia Data Model Architect / system developer

MySQL 4.0                      19 December 2000                     isamchk(1)

References for this manual (incoming links)