Checking Whether the Source Database Tables Use Storage Engines Not Supported by the Destination Database

Whether the source database tables use storage engines not supported by the destination database

Check whether the source database tables use storage engines not supported by the destination database. If yes, the migration fails.

Failure cause: The source database tables use the storage engines that are not supported by the destination database.

Handling suggestion: Go back to the previous page and deselect the tables that use the storage engines not supported by the destination database.

The pre-check fails because the storage engines of tables in the source database are not supported or are null.

• Run the following SQL statement to query the engine of a table that does not meet requirements. In the statement, test indicates the table name, and db indicates the database name.

select engine from information_schema.`tables` where table_name='test' and table_schema = 'db';

• If the storage engine of a table is null, the structure of the table may be damaged or lost. You can run the check table tableName statement to check whether the table structure is valid.