MySQL Utilities 1.6  /  Overview of MySQL Utilities  /  Database Operations

4.2 Database Operations

These utilities are those designed to work at the database-level. They include utilities that can used to manage databases on one or more servers.

  • 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

User Comments
Sign Up Login You must be logged in to post a comment.