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.
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.
Methods of importing data into MariaDB SkySQL vary depending on whether you are importing into transactional or analytical services.
To import data into MariaDB SkySQL for transactional services like Transactional Standalone and HA (Primary/Replica):
Use MariaDB Dump to back up your existing data (excluding the
mysqlsystem database) to an SQL file.
Modify the backup, changing any
DEFINERclauses to use a database user account configured on SkySQL.
Use the MariaDB Client to connect to SkySQL and import the data into your SkySQL service.
Additional information is available in Importing Transactional Data.
For each table of analytical data you want to import into MariaDB SkySQL:
On your existing database, find the table schema with SHOW CREATE TABLE
Use mariadb-dump to back up the table data into a TSV file.
Connect to the SkySQL service with MariaDB Client using the
Use the LOAD DATA INFILE to load the TSV data into the table.
Additional information is available in Importing Analytical Data.
This page was step 4 of 5.