Sign inTry Free

Import and Backup

On this page

How can I backup a SingleStore Helios database?

SingleStore Helios supports consistent, online, workspace-wide BACKUP and RESTORE operations that do not require blocking write operations on the database like mysqldump does.

See Back Up and Restore Data for more information.

How can I import data from MySQL, Postgres, MS-SQL etc?

Refer to Load Data for more information.

How can I easily copy a table?

You can use CREATE TABLE dest AS SELECT * FROM source. See CREATE TABLE.

Or, create a new empty table using the schema of the original table from SHOW CREATE TABLE source and copy data from source table into the new table using INSERT INTO dest SELECT * FROM source.

How can I easily copy a database?

Available options include:

  • BACKUP the database and RESTORE it on the same (or a different) workspace under a different name.

Where are the important data files (recovery log, binary logs, snapshots, data files etc)?

Run SHOW STATUS EXTENDED LIKE '%_directory' to get the full paths.

How do I load data into SingleStore Helios?

The easiest way to get data into SingleStore Helios is by uploading your dataset to Amazon S3 or Google Cloud Storage and using SingleStore Pipelines to ingest your data quickly. Get started now.

How are backups managed?

SingleStore performs daily backups on all data.

You may also manually back up your data. Refer to Back Up and Restore Data for more information.

Last modified: February 7, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK