SHOW-SNAPSHOT

Name

SHOW SNAPSHOT

Description

This statement is used to view backups that already exist in the repository.

grammar:

  1. SHOW SNAPSHOT ON `repo_name`
  2. [WHERE SNAPSHOT = "snapshot" [AND TIMESTAMP = "backup_timestamp"]];

illustrate:

  1. The meanings of the columns are as follows: Snapshot: The name of the backup Timestamp: corresponds to the time version of the backup Status: If the backup is normal, it will display OK, otherwise it will display an error message
  2. If TIMESTAMP is specified, the following additional information is displayed: Database: The name of the database to which the backup data originally belonged Details: In the form of Json, the data directory and file structure of the entire backup are displayed

Example

  1. View the existing backups in the repository example_repo

    1. SHOW SNAPSHOT ON example_repo;

  2. View only the backup named backup1 in the repository example_repo:

    1. SHOW SNAPSHOT ON example_repo WHERE SNAPSHOT = "backup1";

  3. View the details of the backup named backup1 in the warehouse example_repo with the time version “2018-05-05-15-34-26”:

    1. SHOW SNAPSHOT ON example_repo
    2. WHERE SNAPSHOT = "backup1" AND TIMESTAMP = "2018-05-05-15-34-26";

Keywords

  1. SHOW, SNAPSHOT

Best Practice