Database Clone copies table schemas and data from a source MySQL database to a destination MySQL database. Use it to initialize or refresh databases across environments without manual export and import steps. Common scenarios include:
Seeding a test environment with your current development schema and data
Prerequisites
Before you begin, ensure that you have:
Source and destination databases that are both MySQL
Database instances managed in Flexible Management or Stable Change mode. For details, see Control modes
Limitations
Only MySQL databases are supported. The source and destination must both be MySQL.
The database instances to which the source and destination databases belong must be managed in Flexible Management or Stable Change mode.
Clone a database
Log in to the DMS console.
In the top navigation bar, hover over Database Development, then choose Environment Construction > Database Clone.
In the upper-right corner of the Database Clone Tickets page, click Database Clone.
Configure the cloning task:
Parameter Description Task Name A descriptive name for the task Source database (Only Support MySQL) The MySQL database to clone from. Enter a keyword to search and select Destination Database (Only Support MySQL) The MySQL database to clone into. Enter a keyword to search and select Source Tables Tables to clone: Partial Tables (selected tables only) or All Tables (the entire database) Duplicate objects What to do when the destination already has an object with the same name: Skip duplicate name object or Overwrite duplicate name object (warning: the structure and data of the target object will be replaced) Migration Objects Additional programmable objects to clone alongside tables: View, Procedures, functions, triggers, and events Time options When to run the task after ticket approval: Running immediately or Specified time Click Submit.
After the ticket is approved, the cloning task runs automatically according to your time settings.
Verify the result
After the task runs, confirm the clone completed successfully:
On the Ticket Details page, check the ticket status and progress.
Open the SQLConsole for the destination database and query one or more of the cloned tables to confirm the schema and data are present.