Data Import / Data Load

Overview

Data import, or data loading, is often performed when migrating an existing database to MariaDB SkySQL or when preparing a database for testing.

Data can be loaded to SkySQL services with the assistance of SkySQL Support or by using self-service tools. When importing large data sets, we recommend working with SkySQL Support.

Instructions are provided for the following data import methods:

Data Import Method

Use Case

Support-Assisted

Coordinate data import with SkySQL Support

LOAD DATA LOCAL INFILE

Import TSV (tab-delimited) or CSV (comma-delimited) file data using the LOAD DATA LOCAL INFILE statement with your database client

mariadb-import

Import TSV (tab-delimited) or CSV (comma-delimited) file data using the mariadb-import utility

mariadb-dump

Restore a logical backup created using the mariadb-dump utility or mysqldump utility