All Products
Search
Document Center

:Migrate data from a PolarDB database to a MySQL tenant of OceanBase Database

Last Updated:Mar 08, 2023

  1. Create a migration project.

    1. Log on to the ApsaraDB for OceanBase console.

    2. In the left-side navigation pane, choose Data Transmission > Data Migration.

    3. On the Data Migration page, click Create Migration Project in the upper-right corner.

  2. On the Select the Source and the Destination page, specify the following parameters.

    Parameter

    Description

    Migration Project Name

    We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 64 characters in length.

    Source

    If you have created a PolarDB-X 1.0 data source, select it from the drop-down list. Otherwise, click Create Data Source in the drop-down list to create one in the dialog box on the right side. For more information about parameters, see Create a PolarDB-X 1.0 data source.

    Destination

    If you have created a data source for the MySQL tenant of OceanBase Database, select it from the drop-down list. Otherwise, click Create Data Source in the drop-down list to create one in the dialog box on the right side. For more information about parameters, see Create an OceanBase data source.

    Important

    The instance type of the destination database cannot be a self-managed OceanBase data source in VPC.

    Transmission Instance

    Select a purchased transmission instance from the drop-down list. If you have not purchased a transmission instance, click Purchase on the right to purchase one. For more information, see Purchase a transmission instance.

  3. Click Next. On the Select Migration Type page, specify Migration Type for the migration project.

  4. On the Select Migration Objects page, select the migration objects.

    Select Specify Objects. Then select the objects to be migrated on the left and click > to add them to the list on the right. You can select tables and views of one or more databases as the migration objects.

  5. Click Next. On the Migration Options page, configure the parameters.

  6. Click Precheck to start a precheck on the data migration project.