- 13.4 Manual Pages
- 13.4.1 MySQL Utilities Overview — Brief overview of command-line utilities
- 13.4.2 mysqlauditadmin — Allows users to perform maintenance action on the audit log
- 13.4.3 mysqlauditgrep — Allows users to search the current or an archived audit log
- 13.4.4 mysqldbcompare — Compare Two Databases and Identify Differences
- 13.4.5 mysqldbcopy — Copy Database Objects Between Servers
- 13.4.6 mysqldbexport — Export Object Definitions or Data from a Database
- 13.4.7 mysqldbimport — Import Object Definitions or Data into a Database
- 13.4.8 mysqldiff — Identify Differences Among Database Objects
- 13.4.9 mysqldiskusage — Show Database Disk Usage
- 13.4.10 mysqlfailover — Automatic replication health monitoring and failover
- 13.4.11 mysqlindexcheck — Identify Potentially Redundant Table Indexes
- 13.4.12 mysqlmetagrep — Search Database Object Definitions
- 13.4.13 mysqlprocgrep — Search Server Process Lists
- 13.4.14 mysqlreplicate — Set Up and Start Replication Between Two Servers
- 13.4.15 mysqlrpladmin — Administration utility for MySQL replication
- 13.4.16 mysqlrplcheck — Check Replication Prerequisites
- 13.4.17 mysqlrplshow — Show Slaves for Master Server
- 13.4.18 mysqlserverclone — Clone Existing Server to Create New Server
- 13.4.19 mysqlserverinfo — Display Common Diagnostic Information from a Server
- 13.4.20 mysqluc — Command line client for running MySQL Utilities
- 13.4.21 mysqluserclone — Clone Existing User to Create New User
This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples:
Monitor the audit log
Copy, rotate, and configure the audit log
Search the audit log
Output results to different formats
Compare databases on two servers or the same server
Compare definitions and data
Generate a difference report
Generate SQL transformation statements
Copy databases between servers
Clone databases on the same server
Supports rename
Export metadata and/or data from one or more databases
Formats: SQL, CSV, TAB, Grid, Vertical
Import metadata and data from one or more files
Reads all formats from mysqldbexport
Compare object definitions
Generate a difference report
Show disk usage for databases
Generate reports in SQL, CSV, TAB, Grid, Vertical
Performs replication health monitoring
Provides automatic failover on a replication topology
Uses Global Transaction Identifiers (GTID, MySQL Server 5.6.5+)
Read indexes for one or more tables
Check for redundant and duplicate indexes
Generate reports in SQL, CSV, TAB, Grid, Vertical
Search metadata
Regexp, database search
Generate SQL statement for search query
Search process information
Generate SQL statement for search
Kill processes that match query
Setup replication
Start from beginning, current, specific binlog, pos
Administers the replication topology
Allows recovery of the master
Commands include elect, failover, gtid, health, start, stop, and switchover
Check replication configuration
Tests binary logging on master
Show slaves attached to master
Can search recursively
Show the replication topology as a graph or list
Start a new instance of a running server
Show server information
Can search for running servers on a host
Access online or offline servers
Clone a user account, to the same or different server
Show user grants
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
Tests for all utilities
Similar to MTR
Comparative and value result support
Tests written as Python classes
User Comments
Add your own comment.