Data Import/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

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

mariadb-dump

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

  • Distributed Transactions

  • Replicated Transactions

  • Single Node Transactions

mariadb-import

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

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

Support-Assisted

Import large data sets with assistance from SkySQL support

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions