mysqlcheck的日常语法总结

       本篇内容介绍了“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的常用语法总结”的内容就介绍到这里了，感谢大家的阅读。