189 8069 5689
本篇内容介绍了“mysqlcheck的常用语法总结”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！
以下内容主要适用于mysql 5.6，5.5的版本可能有部分选项不可用。
通常使用该工具一般语法为：
| Format | Description | Introduced |
|---|---|---|
| --all-databases | Check all tables in all databases | |
| --all-in-1 | Execute a single statement for each database that names all the tables from that database | |
| --analyze | Analyze the tables | |
| --auto-repair | If a checked table is corrupted, automatically fix it | |
| --bind-address=ip_address | Use specified network interface to connect to MySQL Server | |
| --character-sets-dir=path | Directory where character sets are installed | |
| --check | Check the tables for errors | |
| --check-only-changed | Check only tables that have changed since the last check | |
| --check-upgrade | Invoke CHECK TABLE with the FOR UPGRADE option | |
| --compress | Compress all information sent between client and server | |
| --databases | Process all tables in the named databases | |
| --debug[=debug_options] | Write a debugging log | |
| --debug-check | Print debugging information when program exits | |
| --debug-info | Print debugging information, memory, and CPU statistics when program exits | |
| --default-auth=plugin | Authentication plugin to use | 5.6.2 |
| --default-character-set=charset_name | Specify default character set | |
| --defaults-extra-file=file_name | Read option file in addition to usual option files | |
| --defaults-file=file_name | Read only named option file | |
| --defaults-group-suffix=str | Option group suffix value | |
| --extended | Check and repair tables | |
| --fast | Check only tables that have not been closed properly | |
| --fix-db-names | Convert database names to 5.1 format | |
| --fix-table-names | Convert table names to 5.1 format | |
| --force | Continue even if an SQL error occurs | |
| --help | Display help message and exit | |
| --host=host_name | Connect to MySQL server on given host | |
| --login-path=name | Read login path options from .mylogin.cnf | 5.6.6 |
| --medium-check | Do a check that is faster than an --extended operation | |
| --no-defaults | Read no option files | |
| --optimize | Optimize the tables | |
| --password[=password] | Password to use when connecting to server | |
| --pipe | On Windows, connect to server using named pipe | |
| --plugin-dir=path | Directory where plugins are installed | 5.6.2 |
| --port=port_num | TCP/IP port number to use for connection | |
| --print-defaults | Print defaults | |
| --protocol=type | Connection protocol to use | |
| --quick | The fastest method of checking | |
| --repair | Perform a repair that can fix almost anything except unique keys that are not unique | |
| --secure-auth | Do not send passwords to the server in old (pre-4.1.1) format | 5.6.17 |
| --shared-memory-base-name=name | The name of shared memory to use for shared-memory connections | |
| --silent | Silent mode | |
| --skip-database=db_name | Omit this database from performed operations | 5.6.11 |
| --socket=path | For connections to localhost, the Unix socket file to use | |
| --ssl | Enable SSL for connection | |
| --ssl-ca=file_name | Path of file that contains list of trusted SSL CAs | |
| --ssl-capath=dir_name | Path of directory that contains trusted SSL CA certificates in PEM format | |
| --ssl-cert=file_name | Path of file that contains X509 certificate in PEM format | |
| --ssl-cipher=cipher_list | List of permitted ciphers to use for SSL encryption | |
| --ssl-crl=file_name | Path of file that contains certificate revocation lists | 5.6.3 |
| --ssl-crlpath=dir_name | Path of directory that contains certificate revocation list files | 5.6.3 |
| --ssl-key=file_name | Path of file that contains X509 key in PEM format | |
| --ssl-verify-server-cert | Verify server Common Name value in its certificate against host name used when connecting to server | |
| --tables | Overrides the --databases or -B option | |
| --use-frm | For repair operations on MyISAM tables | |
| --user=user_name, | MySQL user name to use when connecting to server | |
| --verbose | Verbose mode | |
| --version | Display version information and exit | |
| --write-binlog | Log ANALYZE, OPTIMIZE, REPAIR statements to binary log. --skip-write-binlog adds NO_WRITE_TO_BINLOG to these statements. |
“mysqlcheck的常用语法总结”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联-成都网站建设公司网站，小编将为大家输出更多高质量的实用文章！