Back Up and Restore Data
You can make a full backup or an incremental backup of a database.
For backup destinations other than the local filesystem, all leaves must have access to write to the target destination.
Note
This topic applies to database backups made using the BACKUP DATABASE command or using the SingleStore Toolbox sdb-admin create-backup command.
Incremental backups cannot be made on unlimited storage databases.
Unlimited storage databases can be restored (attached) to any point in time using PITR, which is not discussed in this topic.
Caution
SingleStore does not support restoring database backups from a newer version of SingleStore into an older version.
On account of how logs are now captured in SingleStore versions 8.
-
Downgrading from SingleStore versions 8.
9. 19 and later to SingleStore versions 8. 9. 18 and earlier -
Restoring backups from SingleStore versions 8.
9. 19 and later to SingleStore versions 8. 9. 18 and earlier
Release 6.
Databases on a secondary cluster to which the primary database is being replicated cannot be backed up with the BACKUP DATABASE
command.
In this section
Last modified: May 21, 2025