mysqlcheck的常用語法總結(jié)

本篇內(nèi)容介紹了“MySQLcheck的常用語法總結(jié)”的有關知識，在實際案例的操作過程中，不少人都會遇到這樣的困境，接下來就讓小編帶領大家學習一下如何處理這些情況吧！希望大家仔細閱讀，能夠?qū)W有所成！

創(chuàng)新互聯(lián)建站-專業(yè)網(wǎng)站定制、快速模板網(wǎng)站建設、高性價比皇姑網(wǎng)站開發(fā)、企業(yè)建站全套包干低至880元,成熟完善的模板庫,直接使用。一站式皇姑網(wǎng)站制作公司更省心,省錢,快速模板網(wǎng)站建設找我們，業(yè)務覆蓋皇姑地區(qū)。費用合理售后完善，十多年實體公司更值得信賴。

以下內(nèi)容主要適用于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的常用語法總結(jié)”的內(nèi)容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關的知識可以關注創(chuàng)新互聯(lián)網(wǎng)站，小編將為大家輸出更多高質(zhì)量的實用文章！

網(wǎng)頁題目：mysqlcheck的常用語法總結(jié)
瀏覽路徑：http://m.rwnh.cn/article4/jipsoe.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供做網(wǎng)站、虛擬主機、網(wǎng)站設計公司、營銷型網(wǎng)站建設、網(wǎng)站營銷、網(wǎng)站建設

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容

内射老阿姨1区2区3区4区_久久精品人人做人人爽电影蜜月_久久国产精品亚洲77777_99精品又大又爽又粗少妇毛片

mysqlcheck的常用語法總結(jié)