Step 4: Import Data

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, operations features, and standard 24x5 support.

  • 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 Application

During the current step in our guided walkthrough, we will import data to a SkySQL service.

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

Import Data

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

Transactional Data

To import data into MariaDB SkySQL for transactional services like Transactional Standalone and HA (Primary/Replica):

  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 Importing Transactional Data.

Analytical Data

For each table of analytical data you want to import into MariaDB SkySQL:

  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 Importing Analytical Data.

Next Step

  • This page was step 4 of 5.