4.1. Database Operations

hese utilities are those designed to work at the database-level. They include utilities that can used to adminster 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

Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb
EPUB - 292.9Kb
HTML Download (TGZ) - 224.3Kb
HTML Download (Zip) - 236.0Kb
User Comments
Sign Up Login You must be logged in to post a comment.