4.1.1 Import Data

This topic describes how to import data into the DB System.

Before You Begin

• Review the Requirements.

Import Data

Use MySQL Shell Shell for importing data into a DB System. Its dump and load utilities are specifically built for this task and support all types of data exports and imports. You can export data to Object Storage and also import it from there. Ensure that the source MySQL version is 5.7.9 or higher.

• For MySQL HeatWave on OCI, see Importing and Exporting Databases in the MySQL HeatWave on OCI Service Guide.

• For MySQL HeatWave on AWS, see Importing Data in the MySQL HeatWave on AWS Service Guide.

• For MySQL HeatWave for Azure, see Importing Data to MySQL HeatWave in the MySQL HeatWave for Azure Service Guide.

Tip

For an OLTP workload that resides in an on-premise instance of MySQL Server, inbound replication is recommended for replicating data to the DB System for offload to the MySQL HeatWave Cluster. For more information, see Replication in the MySQL HeatWave on OCI Service Guide.

What's Next

• Learn how to Bulk Ingest Data to MySQL Server.