Exporting 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