3.1.2.5 MySQL Storage Engines

MySQL HeatWave on AWS supports only the InnoDB storage engine.

If you intend to migrate to MySQL HeatWave on AWS, and are not currently using the InnoDB storage engine, your data must be converted to use the InnoDB storage engine before the data is imported.

You can manually convert tables to InnoDB using the following ALTER TABLE statement:

mysql> ALTER TABLE table_name ENGINE=InnoDB;

The recommended method for migrating data is to use the MySQL Shell client. MySQL Shell dump utilities provide a ocimds option that checks for various incompatibilities, including tables defined with unsupported storage engines. Should incompatibilities exist, the MySQL Shell compatibility option can be used to alter MySQL Shell dump files to fix the incompatibilities, including changing the storage engine to InnoDB. For more information, see Importing Data.

Parent topic: MySQL Server