Step 4: Import Data

Overview

This page details step 4 of a 5-step guided walkthrough to help you get started with SkySQL.

In this step, you will import data to your SkySQL service.

How is data protected?

MariaDB SkySQL delivers enterprise-grade cloud database services for mission-critical applications.

  • MariaDB SkySQL is built on MariaDB Enterprise Server, optimized for security, stability, and reliability in demanding production environments.

  • Multi-node database deployments feature a rigorous SLA, High Availability (HA) features, and operations features.

  • Enterprise and Platinum support options extend support to 24x7, with the additional option of SkyDBA for reactive and proactive assistance from a team of expert DBAs.

  • Security features are designed to meet the GRC and infosec challenges faced by modern applications. For example, SkySQL features transparent data-at-rest-encryption.

Optional Sample Data and Code

If you do not have a data set to import for this step, you may want to skip ahead to step 5 and deploy the sample code.

Import Data

Methods of importing data into MariaDB SkySQL vary depending on whether you are importing into transactional or analytical services.

Import Data for Transactions

To import data into MariaDB SkySQL for transactional services like the Single Node Transactions service in this walkthrough:

  1. Use MariaDB Dump to back up your existing data (excluding the mysql system database) to an SQL file.

  2. Modify the backup, changing any DEFINER clauses to use a database user account configured on SkySQL.

  3. Use the MariaDB Client to connect to SkySQL and import the data into your SkySQL service.

Additional information is available in Data Import/Load.

Import Data for Analytics

For each table you want to import into a MariaDB SkySQL Analytics service:

  1. On your existing database, find the table schema with SHOW CREATE TABLE

  2. Use mariadb-dump to back up the table data into a TSV file.

  3. Connect to the SkySQL service with MariaDB Client using the --local-infile option.

  4. Use the CREATE DATABASE and CREATE TABLE statements to recreate the schema, setting the ENGINE table option to ColumnStore.

  5. Use the LOAD DATA INFILE to load the TSV data into the table.

Additional information is available in Data Import/Load.

Next Step

  • This page was step 4 of 5.