MySQL Utilities Operations Management database MySQL Tutorial

MySQL Utilities provides a range of MySQL server and database management tools. Full support for MySQL5.1 and above versions, also compatible with MySQL5.0 versions, although some features are not supported. MySQL4.0 version is not supported.

In the following sections, you will describe administrative tasks such as requirements, objectives, execution methods, specific scenarios, and descriptions, as well as specific permissions that are required.

The following tools work at the database level and can be used to manage databases for one or more servers.

1. Mysqldbcompare

Compare two servers or databases on the same server
Comparing definition files and data
Generate Variance Report
Generate Differential Conversion SQL statements

2. Mysqldbcopy

Replicating databases between servers
Cloning a database on the same server
Support for renaming

3. Mysqldbexport

Export meta data and or data from one or more databases
Supported formats: SQL, CSV, TAB, Grid, Vertical

4. MYsqldbimport

Import meta data and data from one or more files
Support Mysqldbexport various formats

5. Mysqldiff

The definition of the comparison object
reports that produce discrepancies

Take a look at the application of each tool in detail.