SHOW-BACKUP
SHOW-BACKUP
Name
SHOW BACKUP
Description
This statement is used to view BACKUP tasks
grammar:
SHOW BACKUP [FROM db_name]
[WHERE SnapshotName ( LIKE | = ) 'snapshot name']
illustrate:
- Only the most recent BACKUP task is saved in Doris.
- The meaning of each column is as follows:
JobId
: Unique job idSnapshotName
: The name of the backupDbName
: belongs to the databaseState
: current stagePENDING
: The initial state after submitting the jobSNAPSHOTING
: Executing snapshotUPLOAD_SNAPSHOT
: Snapshot completed, ready to uploadUPLOADING
: Snapshot uploadingSAVE_META
: Save job meta information to a local fileUPLOAD_INFO
: Upload job meta informationFINISHED
: The job was successfulCANCELLED
: Job failed
BackupObjs
: Backed up tables and partitionsCreateTime
: task submission timeSnapshotFinishedTime
: Snapshot completion timeUploadFinishedTime
: Snapshot upload completion timeFinishedTime
: Job finish timeUnfinishedTasks
: Displays unfinished subtask ids during SNAPSHOTING and UPLOADING stagesStatus
: If the job fails, display the failure messageTimeout
: Job timeout, in seconds
Example
View the last BACKUP task under example_db.
SHOW BACKUP FROM example_db;
Keywords
SHOW, BACKUP