All Products
Search
Document Center

Data Transmission Service:Failed to check the MySQL storage engine during DTS incremental data migration

Last Updated:Aug 30, 2023

Problem description

Before you start incremental data migration between MySQL databases, DTS checks storage engines of the source database during the precheck. This topic describes how to fix the issue detected by the Storage Engine check item.

Causes

This item checks whether storage engines of the source database support incremental data migration. The FEDERATED and MRG_MyISAM storage engines do not support incremental data migration between MySQL databases. If this item fails to pass the precheck, the source database may have one of the preceding unsupported storage engines. The following shows how to fix the issue.

Solution

  1. In Precheck dialog box, click storage Engine prompt button on the right side of the column.

  2. In the View More dialog box, view the table name prompted in the Cause of Failure. In this example, it is the customer2 table in the mysqltest database.

  3. Find the target migration task and click Edit Task.

  4. In the lower-right corner of the page, click Set Whitelist and Next to go to the next step.

  5. Select the tables whose storage engines fail to pass the PreCheck and remove them from the selected section.

  6. Click Precheck.

More information

To migrate tables with FEDERATED and MRG_MYISAM storage engines, you can create a data migration task for the tables. Select Schema Migration and Full Data Migration.