1、通过mysqluc获取帮助###可以通过调用mysqluc命令行工具来获取这些工具的帮助信息### mysqluc提供一个自带的命令行提示符窗口，在这个窗口下也可以完成相应的命令操作[root@node1 ~]# mysqlucLaunching console ...Welcome to the MySQL Utilities Client （mysqluc） version 1.6.4Copyright （c） 2010, 2016 Oracle and/or its affiliates. All rights reserved.This is a release of dual licensed MySQL Utilities. For the avoidance ofdoubt, this particular copy of the software is releasedunder the version 2 of the GNU General Public License.MySQL Utilities is brought to you by Oracle.Type "help" for a list of commands or press TAB twice for list of utilities.mysqluc> helpCommand Description-------------------------------------------------------------------------help utilitiesDisplay list of all utilities supported. help <utility>Display help for a specific utility. show errors Display errors captured during the execution of theutilities. clear errorsclear captured errors. show last error Display the last error captured during the execution of the utilities help | help commandsShow this list.exit | quit Exit the console.set <variable>=<value>Store a variable for recall in commands. show optionsDisplay list of options specified by the user on launch.show variablesDisplay list of variables. <ENTER> Press ENTER to execute command.<ESCAPE>Press ESCAPE to clear the command entry. <DOWN>Press DOWN to retrieve the previous command. <UP>Press UP to retrieve the next command in history.<TAB> Press TAB for type completion of utility, option,or variable names. <TAB><TAB>Press TAB twice for list of matching typecompletion （context sensitive）.###查看utilities包中所有的命令行工具mysqluc> help utilities UtilityDescription -------------------------------------------------------------------------mysqlauditadminaudit log maintenance utility mysqlauditgrep audit log search utilitymysqlbinlogmovebinary log relocate utility mysqlbinlogpurge purges unnecessary binary log files mysqlbinlogrotaterotates the active binary log filemysqldbcompare compare databases for consistency mysqldbcopycopy databases from one server to another mysqldbexportexport metadata and data from databases mysqldbimportimport metadata and data from files mysqldiffcompare object definitions among objects where the difference is how db1.obj1 differs from db2.obj2mysqldiskusage show disk usage for databases mysqlfailoverautomatic replication health monitoring and failovermysqlfrm show CREATE TABLE from .frm files mysqlgrantsdisplay grants per object mysqlindexcheckcheck for duplicate or redundant indexesmysqlmetagrepsearch metadata mysqlprocgrepsearch process informationmysqlreplicate establish replication with a master mysqlrpladminadministration utility for MySQL replicationmysqlrplcheckcheck replication mysqlrplms establish multi-source replicationmysqlrplshow show slaves attached to a mastermysqlrplsync replication synchronization checker utility mysqlserverclone start another instance of a running servermysqlserverinfoshow server information mysqlslavetrxskip transactions on slaves mysqluserclone clone a MySQL user account to one or more new users ###也可直接在mysqluc提示符下输入 help command 来获取对应命令的帮助信息，如下mysqluc> help mysqlauditadmin Usage: mysqlauditadmin --server=user:pass@host:port --show-options # Author : Leshami# Blog : http://www.linuxidc.commysqlauditadmin - audit log maintenance utility Options:Option Description ---------------------------------------------------------------------------versionshow program"s version number and exit--help display this help message and exit--licensedisplay program"s license and exit--server=SERVERconnection information for the server in the form:<user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>] or <config-path>[<[group]>]. --audit-log-name=LOG_NAMEfull path and file name for the audit log file.Used for stats and copy options.--show-options display the audit log system variables. --remote-login=RLOGINuser name and host to be used for remote login for copying log files. Format: <user>:<host_or_ip> Password will be prompted.--file-stats display the audit log file statistics.--copy-to=COPY_LOCATIONthe location to copy the audit log filespecified. The path must be locally accessible for the current user. --value=VALUEvalue used to set variables based on the command specified. See --help for list per command. --ssl-ca=SSL_CApath to a file that contains a list of trusted SSL CAs.--ssl-cert=SSL_CERTname of the SSL certificate file to use forestablishing a secure connection. --ssl-key=SSL_KEYname of the SSL key file to use for establishing a secure connection.--ssl=SSLspecifies if the server connection requires useof SSL. If an encrypted connection cannot be established, the connection attempt fails. Bydefault 0 （SSL not required）. -v, --verbosecontrol how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug Available Commands: copy - copy the audit log to a locally accessible path policy - set the audit log policy Values = ALL, NONE, LOGINS, QUERIES,DEFAULT rotate - perform audit log rotationrotate_on_size - set the rotate log size limit for auto rotation Values = 0, 42949672952、直接在shell提示符下获取命令帮助###如下示例[root@node1 ~]# mysqlfailover --help|headMySQL Utilities mysqlfailover version 1.6.4 License type: GPLv2Usage: mysqlfailover --master=root@localhost --discover-slaves-login=root --candidates=root@host123:3306,root@host456:3306 mysqlfailover - automatic replication health monitoring and failoverOptions:--version show program"s version number and exit--helpdisplay this help message and exit--license display program"s license and exit 3、基于Linux man获取命令帮助###如下示例root@node1 ~]# man mysqlfailoverMYSQLFAILOVER（1）MySQL Utilities MYSQLFAILOVER（1）NAME mysqlfailover - Automatic replication master failoverSYNOPSIS mysqlfailover [options]本文永久更新链接地址
易网时代-编程资源站