Unix/Linux Go Back    

OpenSolaris 2009.06 - man page for isamchk (opensolaris section 1)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)

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-charac-
       ter-set=...]  [-d|--description] [-e|--extend-check] [-f|--force] [-?|--help] [-i|--infor-
       mation]	   [-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 MySQL faster.

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

	      Directory where character sets are

	      Set the default character set

	      Prints some information about table.

	      Check the table VERY thoroughly.	One need use this only in extreme cases as  isam-
	      chk should normally find all errors even without this switch

	      Overwrite  old temporary files.  If one uses -f when checking tables (running isam-
	      chk 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 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 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 couple 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 silent

	      Sort index blocks.  This speeds up 'read-next' in 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 the first time!)

	      Unpack file packed with pack_isam.

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

	      Print version and exit.

	      Wait if table is locked.

       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)

       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/

       Please refer to http://bugs.mysql.com/ to report bugs.

       Ver  1.0,  distribution	4.0.24	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

       See attributes(5) for descriptions of the following attributes:

       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       |Interface Stability | External				 |
       Source for mysql is available on http://opensolaris.org.

MySQL 4.0				 19 December 2000			       isamchk(1)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums

All times are GMT -4. The time now is 08:25 PM.