Data Import / Data Load

Overview

MariaDB SkySQL supports multiple methods for data import:

LOAD DATA LOCAL INFILE

Import from a TSV/CSV file using the LOAD DATA LOCAL INFILE statement

  • Enterprise Server Single Node

  • Enterprise Server With Replica(s)

  • Xpand Distributed SQL

  • ColumnStore Data Warehouse

mariadb-dump

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

  • Enterprise Server Single Node

  • Enterprise Server With Replica(s)

  • Xpand Distributed SQL

mariadb-import

Import from a TSV/CSV file using the mariadb-import utility

  • Enterprise Server Single Node

  • Enterprise Server With Replica(s)

  • Xpand Distributed SQL

  • ColumnStore Data Warehouse

Support-Assisted

Import large data sets with assistance from SkySQL support

  • Enterprise Server Single Node

  • Enterprise Server With Replica(s)

  • Xpand Distributed SQL

  • ColumnStore Data Warehouse