Importing Using the Data Import Feature
Use the data import feature to import data from an Object Storage bucket to a standalone DB system.
You can import to a standalone DB system in the same region as the Object Storage bucket only. Also, you can import a dump while it is still being exported to an Object Storage bucket, but this may prevent bulk ingest from being used.
To import data to a high availability DB system, first import data to a standalone DB system and then enable high availability.
HeatWave can use bulk ingest to speed up the data import when the following conditions are met:
- The MySQL version of the DB system is 8.4.0 or higher.
- The CSV file is not compressed or compressed with the
zstd
compression. - The column terminator in the CSV file is a single-byte character.
- The table has an explicitly created primary key that does not use prefix index. GIPK (Generated Invisible Primary Key) is not supported.
- The table uses a file-per-table tablespace.
- The table uses the dynamic row format.
- The table has no generated (virtual or stored) columns.
- The table has no CHECK constraints.
- The table only use the following supported data types:
- INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT (UNSIGNED is supported)
- NUMERIC, DECIMAL (UNSIGNED is not supported, deprecated in MySQL 8.0.17)
- FLOAT, DOUBLE (UNSIGNED is not supported, deprecated in MySQL 8.0.17)
- CHAR, VARCHAR (No large data support, record must fit in page)
- DATE, DATETIME
- In version 9.0 or higher, the table can also use the following supported data types:
- TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT
- JSON
- VARCHAR (Support the maximum length)
Note
It is recommended to import data using the data import feature in the Console. The import is managed by the HeatWave Service and optimized for fast import processing.
It is recommended to import data using the data import feature in the Console. The import is managed by the HeatWave Service and optimized for fast import processing.
Note
You should use the latest version of MySQL Shell to export the data with the
You should use the latest version of MySQL Shell to export the data with the
ocimds
option enabled. This can avoid potential data import errors.