isamchk(1) [redhat man page]
ISAMCHK(1) General Commands Manual 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-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 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 isamchk should normally find all errors even without this switch -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. -?|--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 origi- nal 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 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.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). 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.mer- curmedia.com) 19 December 2000 ISAMCHK(1)
Check Out this Related Man Page
MYSQLADMIN(1) General Commands Manual MYSQLADMIN(1) NAME
mysqladmin [OPTIONS] command command.... - A utility for performing administrative operations OPTION SYNOPSIS
mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help] [--character-sets-dir=directory] [-C|--compress] [-h|--host=[#]] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-i|--sleep= sec] [-E|--vertical] [-s|--silent] [-S|--socket= #] [-r|--relative] [-t|--timeout= #] [-u|--user= uname] [-v|--verbose] [-V|--version] [-w|--wait[=retries]] OPTION DESCRIPTION
You can get a list of the options your version of mysqladmin supports by executing mysqladmin --help OPTIONS
-#|--debug=logfile Output debug log. Often this is 'd:t:o,filename` -f|--force Don't ask for confirmation on drop database; with multiple commands, continue even if an error occurs -?|--help Display help and exit --character-sets-dir=directory Set the character set directory -C|--compress Use compression in server/client protocol -h|--host=hostname Connect to host -p|--password[=pwd] Password to use when connecting to server If password is not given it's asked from the tty -P|--port=pnum Port number to use for connection -i|--sleep=sec Execute commands again and again with a sleep between -r|--relative Show difference between current and previous values when used with -i extended-status -E|--vertical Print output vertically. Is similar to --relative, but prints output vertically. -s|--silent Silently exit if one can't connect to server -S|--socket=file Socket file to use for connection -t|--timeout=sec Timeout for connection to the mysqld server -u|--user=uname User for login if not current user -v|--verbose Write more information -V|--version Output version information and exit -w|--wait Wait and retry if connection is down COMMAND SYNOPSIS
MySQLADMIN [create databasename ] [drop databasename] [extended-status] [flush-hosts] [flush-logs] [flush-tables] [flush-privileges] [ kill id,id,... ] [password new-password ] [ping] [processlist] [reload] [refresh] [shutdown] [slave-start] [slave-stop] [status] [variables] [version] COMMANDS
Where command is a one or more of: (Commands may be shortened) create databasename Create a new database drop databasename Delete a database and all its tables extended-status Gives an extended status message from the server flush-hosts Flush all cached hosts flush-logs Flush all logs flush-status Clear status variables flush-tables Flush all tables flush-threads Flush the thread cache flush-privileges Reload grant tables (same as reload) kill id,id,... Kill mysql threads password new-password Change old password to new-password ping Check if mysqld is alive processlist Show list of active threads in server reload Reload grant tables refresh Flush all tables and close and open logfiles shutdown Take server down status Gives a short status message from the server variables Prints variables available version Get version info from server 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.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). 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.mer- curmedia.com) 18 December 2000 MYSQLADMIN(1)