MV_BACKUP_HISTORY
This view stores information about backups that have been made.
Column | Description |
---|---|
| A unique identifier for the backup. |
| Name of the workspace that carried out the backup. |
| Unique id that can identify a workspace (see |
| Name of the database that was backed up. |
| Timestamp at which the backup started. |
| Timestamp at which the backup completed. |
| Number of partitions for the backup. |
| Path to where the backup file was placed after backup completed. |
| Concatenated CRC32C checksum of all backup files. |
| Status of backup - Success or Failure. |
| For full backups: size of all backup files, in megabytes. For incremental backups: size of the changes (the incremental differences), in megabytes. |
| A unique identifier for an incremental backup. If the backup is a full backup instead of an incremental backup, |
| Possible values are |
| The values of |
| The SingleStoreDB Cloud version. |
| The amount of memory (MB) used by the database before performing a backup. |
| The type of backup: |
| The global logical timestamp used to perform the backup if implementation is |
Example - this query shows the last successful backup:
SELECT backup_id, database_name, backup_path, lockfree_timestamp FROM information_schema.mv_backup_history WHERE status = 'Success' AND implementation = 'Lockfree' ORDER BY backup_id;
Note: information_schema.MV_BACKUP_HISTORY
is populated only when the BACKUP DATABASE
command is run to create a database backup.