👤
Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:
Select Section of Man Page:
Select Man Page Repository:

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

isamchk(1)				  MySQL database			       isamchk(1)

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

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  isam-
	      chk should normally find all errors even without this switch

       -f|--force
	      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.

       -?|--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. Normally 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 ver-
	      bosity!

       -V|--version
	      Print version and exit.

       -w|--wait
	      Wait if table is locked.

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)

       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/

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

AUTHOR
       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
       (http://www.mercurmedia.com)

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

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

MySQL 4.0				 19 December 2000			       isamchk(1)


All times are GMT -4. The time now is 01:32 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password