SHOW-BACKUP

Name

SHOW BACKUP

Description

This statement is used to view BACKUP tasks

grammar:

  1.  SHOW BACKUP [FROM db_name]

illustrate:

  1. Only the most recent BACKUP task is saved in Doris.
  2. The meaning of each column is as follows: JobId: Unique job id SnapshotName: The name of the backup DbName: belongs to the database 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 BackupObjs: Backed up tables and partitions CreateTime: task submission time SnapshotFinishedTime: Snapshot completion time UploadFinishedTime: Snapshot upload completion time FinishedTime: Job finish time UnfinishedTasks: Displays unfinished subtask ids during SNAPSHOTING and UPLOADING stages Status: If the job fails, display the failure message 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