SHOW-BACKUP

Name

SHOW BACKUP

Description

This statement is used to view BACKUP tasks

grammar:

1. SHOW BACKUP [FROM db_name]
2. [WHERE SnapshotName ( LIKE | = ) 'snapshot name']

illustrate:

  1. Only the most recent BACKUP task is saved in Doris.
  2. The meaning of each column is as follows:
  3. JobId: Unique job id
  4. SnapshotName: The name of the backup
  5. DbName: belongs to the database
  6. State: current stage
    • PENDING: The initial state after submitting the job
    • SNAPSHOTING: Executing snapshot
    • UPLOAD_SNAPSHOT: Snapshot completed, ready to upload
    • UPLOADING: Snapshot uploading
    • SAVE_META: Save job meta information to a local file
    • UPLOAD_INFO: Upload job meta information
    • FINISHED: The job was successful
    • CANCELLED: Job failed
  7. BackupObjs: Backed up tables and partitions
  8. CreateTime: task submission time
  9. SnapshotFinishedTime: Snapshot completion time
  10. UploadFinishedTime: Snapshot upload completion time
  11. FinishedTime: Job finish time
  12. UnfinishedTasks: Displays unfinished subtask ids during SNAPSHOTING and UPLOADING stages
  13. Status: If the job fails, display the failure message
  14. Timeout: Job timeout, in seconds

Example

  1. View the last BACKUP task under example_db.

1. SHOW BACKUP FROM example_db;

Keywords

1. SHOW, BACKUP

Best Practice