MySQL in a Nutshell, 2nd Edition

Name

mysqlcheck

Synopsis

mysqlcheck [options] database [table]

This utility checks, repairs, and optimizes MyISAM tables. It works in part on tables for other storage engines as well. It uses the ANALYZE TABLE, CHECK TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements. Therefore, if the storage engine supports any of these statements, the operations that can be performed by supported statements can be done using this utility. For MyISAM tables, this utility is similar in use and purpose to myisamchk. Instead of working with the table files directly as myisamchk does, though, this utility interacts with the MySQL server.

The name of the database containing the tables to check is given as the second argument to the utility. The table to check is given as the third argument. Additional tables may be given in a space-separated list.

Here is a list of options that you can give and a brief explanation of each:

--all-databases, -A: This option checks all databases.
--all-in-1, -1: This option executes all queries for all tables in each database in one statement rather than as separate queries for each table.
--analyze, -a: This option analyzes tables.
--auto-repair: This option automatically repairs any corrupted tables found.
--character-sets-dir=path: This option specifies the directory containing character sets.
--check, -c: This option checks tables for errors.
--check-only-changed, -C: This option checks only tables that have changed since the last check, as well as tables that were not closed properly.
--compress: This option compresses data passed between the utility and the server, if compression is supported.
--databases databases, -B databases: This option specifies more than one database for checking. To specify tables along with databases with this option, use the --tables option.
--debug[=options], -# [options]: This option logs debugging information. The set of options used by default is 'd:t:o,logname'. See Table 16-1 at the end of the list of options under the mysqldump utility for an explanation of these flags and others that may be used.
--debug-check: This option writes debugging information to the log when the utility ends. It’s available as of version 5.1.21 of MySQL.
--debug-info: This option writes debugging information and CPU and memory usage information to the log after the utility ends.
--default-character-set=set: This option specifies the default character set. Enter SHOW CHARACTER SET; on the server for a list of character sets available.
--extended, -e: This option ensures consistency of data when checking tables. When repairing tables with this option, the utility will attempt to recover all rows, including intentionally deleted ones.
--fast, -F: This option checks only tables that were improperly closed.
--fix-db-names: This option converts the names of databases that contain characters no longer permitted by MySQL as of version 5.1. It’s available as of version 5.1.7 of MySQL.
--fix-table-names: This option converts the names of tables that contain characters no longer permitted by MySQL as of version 5.1. It’s available as of version 5.1.7.
--force, -f: This option forces processing of tables regardless of SQL errors encountered.
--help, -?: This option displays basic help information.
--host=host, -h host: This option specifies the name or IP address of the server for connection.
--medium-check, -m: This option is more thorough than --check but less thorough than --extended.
--optimize, -o: This option optimizes tables.
--password[=password], -p[password]: This option provides the password to pass to the server. A space is not permitted after -p if the password is given.
--port=port, -P port: This option specifies the port to use for connecting to the server. The default is 3306.
--protocol=protocol: This option specifies the protocol to use when connecting to the server. The choices are TCP, SOCKET, PIPE, and MEMORY.
--quick, -q: This option checks tables faster by not scanning rows for incorrect links. When used to repair tables, it has the utility repair only the index tree. This option is the fastest method.
--repair, -r: This option repairs tables. Note that it can’t repair unique keys containing duplicates.
--silent, -s: This option suppresses all messages except for error messages.
--socket=filename, -S filename: This option provides the name of the server’s socket file.
--ssl: This option specifies that secure SSL connections should be used. It requires the server to have SSL enabled. If this option is enabled on the utility by default, use --skip-ssl to disable it.
--ssl-ca=pem_file: This option specifies the name of the file (i.e., the pem file) containing a list of trusted SSL CAs.
--ssl-capath=path: This option specifies the path to the trusted certificates file (i.e., the pem file).
--ssl-cert=filename: This option specifies the name of the SSL certificate file to use for SSL connections.
--ssl-cipher=ciphers: This option gives a list of ciphers that may be used for SSL encryption.
--ssl-key=filename: This option specifies the SSL key file to use for secure connections.
--ssl-verify-server-cert: This option verifies the client’s certificate against the server’s certificate for the client at startup. It is available as of version 5.1.11 of MySQL.
--tables: This option specifies table names when using the --databases option.
--use-frm: This option uses the table structure in the .frm file for repairing a corrupted index.
--user=user, -u user: This option specifies the username for connecting to the server.
--verbose, -v: This option displays more information.
--version, -V: This option displays the version of the utility.

Table of Contents for MySQL in a Nutshell, 2nd Edition

Name

Synopsis

Table of Contents for
MySQL in a Nutshell, 2nd Edition