How to backup all databases in a SingleStore Cluster?
In this article, we will discuss how to backup all databases in a SingleStore cluster.
It is not possible to do a backup of all databases in bulk using the
BACKUP DATABASE command but you can use
sdb-admin create-backup it to do so.
Backup of all databases at once can be achieved by using the SingleStore Toolbox command below:
sdb-admin create-backup --repository "s3://singlestore-backup/destination?region=eu-central-1" --include "*"
We can use a wildcard like
--include "*" to perform all DB selections,
--include GLOB Backup all databases matching GLOB (e.g. "*", "foo*", "*bar")
Click here to check the other options available with
SingleStore CloudDB Clusters:
It's not possible to use SingleStore tools with SingleStore CloudDB (Managed Service), instead, we can only use the BACKUP DATABASE command for each database.
Click here to learn about performing BACKUP and RESTORE on SingleStore Cloud.