MySQL Utilities
This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples:
mysqlauditadmin
Monitor the audit log. Copy, rotate, and configure the audit log
mysqlauditgrep
Search the audit log. Output results to different formats
mysqldbcompare
Compare databases on two servers or the same server. Compare definitions and data. Generate a difference report. Generate SQL transformation statements
mysqldbcopy
Copy databases between servers. Clone databases on the same server. Supports rename
mysqldbexport
Export metadata and/or data from one or more databases. Formats: SQL, CSV, TAB, Grid, Vertical
mysqldbimport
Import metadata and data from one or more files. Reads all formats from mysqldbexport
mysqldiff
Compare object definitions. Generate a difference report
mysqldiskusage
Show disk usage for databases. Generate reports in SQL, CSV, TAB, Grid, Vertical
mysqlfailover
Performs replication health monitoring. Provides automatic failover on a replication topology. Uses Global Transaction Identifiers (GTID, MySQL Server 5.6.5+)
mysqlindexcheck
Read indexes for one or more tables. Check for redundant and duplicate indexes. Generate reports in SQL, CSV, TAB, Grid, Vertical
mysqlmetagrep
Search metadata. Regexp, database search. Generate SQL statement for search query
mysqlprocgrep
Search process information. Generate SQL statement for search. Kill processes that match query.
mysqlreplicate
Setup replication. Start from beginning, current, specific binlog, pos
mysqlrpladmin
Administers the replication topology. Allows recovery of the master. Commands include elect, failover, gtid, health, start, stop, and switchover
mysqlrplcheck
Check replication configuration. Tests binary logging on master
mysqlrplshow
Show slaves attached to master. Can search recursively. Show the replication topology as a graph or list
mysqlserverclone
Start a new instance of a running server
mysqlserverinfo
Show server information. Can search for running servers on a host. Access online or offline servers
mysqluserclone
Clone a user account, to the same or different server. Show user grants
mysqluc
Command line client for running MySQL Utilities. Allows a persistent connection to a MySQL Server. Tab completion for utility names and options. Allows calling the commands with shorter names, such as using “serverinfo” instead of mysqlserverinfo
mut
Tests for all utilities. Similar to MTR. Comparative and value result support. Tests written as Python classes
source: http://dev.mysql.com/doc/workbench/en/mysql-utils-man-overview.html