SingleStore Managed Service

Back Up and Restore Data

With SingleStore you can back up a database and later restore it.

You can make a full backup or an incremental backup of a database. When you make a backup, you can target local file systems (only for full backups), network file systems, Azure, Google Cloud Storage, S3, and S3 Compatible Storage. Note that for backup destinations other than the local filesystem, all leaves must have access to write to the target destination.

Notice

This topic applies to database backups made using the BACKUP DATABASE command.

Incremental backups cannot be made on unlimited storage databases.Local and Unlimited Database Storage Concepts

Caution

SingleStore does not support restoring database backups from a newer version of SingleStore into an older version.

Databases on a secondary cluster to which the primary database is being replicated cannot be backed up with the BACKUP DATABASE command.

Store database backups in a safe place. You should use the built-in functionality that automatically copies local backups to Azure, Google Cloud Storage, S3, or S3 Compatible Storage. Alternatively, manually copy local file system backups and network file system backups to another location for safekeeping.