Help Center/ Distributed Database Middleware/ User Guide/ Schema Management/ Importing Schema Information
Updated on 2026-08-04 GMT+08:00
View PDF
Share

Importing Schema Information

When you deploy DR or migrate data across regions, you can import schema information into destination DDM instances. The imported information includes schema information and shard information, excluding service data and index data.

Prerequisites

The DDM instance has no schemas.

The kernel version of the destination instance must be 3.1.1 or later.

Procedure

  1. Log in to the DDM console.
  2. In the instance list, locate a target instance and click its name.
  3. On the displayed page, in the navigation pane, choose Schemas.
  4. On the displayed page, click Import Schema Information.

    More than one JSON file can be imported into a DDM instance in the premise that the DDM instance does not have schemas with the same names as those in the JSON file.

  5. On the displayed page, click Upload to select the JSON file exported in Exporting Schema Information, select the required data nodes, enter a database account with the required permissions and its password, select The value of the RDS password complexity parameter validate_password_policy (in version 5.7) or validate_password.policy (in version 8.0) will be automatically changed from MEDIUM or STRONG to LOW to ensure that a built-in account can be successfully created for connecting to RDS for MySQL. After the account is created, the parameter settings are restored., and click Finish.

    • The number of selected data nodes is the same as the number of data nodes imported into the DDM instance.
    • Required permissions: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, and TRIGGER WITH GRANT OPTION

Parent topic: Schema Management