Sign inTry Free

Export Data

On this page

Note

If you are running SingleStore Helios, use the endpoint to run the commands discussed in this topic.

This topic describes how to export data from SingleStore databases.

Export a Single Database

In SingleStore Helios, you can use the endpoint to run mysqldump that creates a .sql file containing the queries necessary to recreate a database. For example, if you have a database named “foo”, you can create a backup with the following command:

mysqldump -h 127.0.0.1 -u root -P 3306 foo > foo.sql

Export All Databases

In SingleStore Helios, use the endpoint to run the command mysqldump. For example:

mysqldump -h 127.0.0.1 -u root -P 3306 --all-databases > full_backup.sql

Last modified: July 29, 2024

Was this article helpful?

On this page

Was this article helpful?