# Export Data

> **📝 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:

```shell
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:

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

***

Modified at: July 29, 2024

Source: [/cloud/manage-data/export-data/](https://docs.singlestore.com/cloud/manage-data/export-data/)

(An index of the documentation is available at /llms.txt)