mysqlcheck的日常语法总结
发布时间：2022-01-20 01:06:48 所属栏目：MySql教程 来源：互联网
导读：本篇内容介绍了mysqlcheck的常用语法总结的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！ 以下内容主要适用于mysql 5.6，5.5的版本可能有部分选项不可
|
本篇内容介绍了“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的常用语法总结”的内容就介绍到这里了，感谢大家的阅读。 （编辑：财气旺网 - 财气网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐