Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

Moving Data Between Databases

There are ways to move your data between databases depending on whether SingleStore Helios or SingleStore Self-Managed is where the data is being accessed.

SELECT ... INTO OUTFILE , then LOAD DATA INFILE.

SQL

SELECT * FROM table_name_1 INTO OUTFILE '/home/username/file_name.csv'
        FIELDS TERMINATED BY ','
        LINES TERMINATED BY '\n';

LOAD DATA INFILE '/home/username/file_name.csv'
        INTO TABLE table_name_2;

mysqldump with or without filters.

Shell

mysqldump -uroot -p db_name table_name [--where='id<1000000']

SELECT ... INTO , CREATE PIPELINE AS LOAD DATA, then START PIPELINE. The following example uses S3, but this will work for HDFS, GCS, KAFKS, FS, and AZURE as well.

SQL

SELECT * FROM table_name_1
INTO S3 bucket/target
CONFIG configuration_json
CREDENTIALS credentials_json

CREATE PIPELINE pipeline_name AS LOAD DATA S3 'bucket-name' | '<bucket-name/path>'
      [CONFIG '<configuration_json>']
      CREDENTIALS '<credentials_json>'
INTO TABLE table_name_2;

START PIPELINE pipeline_name;

Moving Data Between Databases

Was this article helpful?

Was this article helpful?