Skip to main content
Version: 2.5

SHOW SNAPSHOT

Description

Views data snapshots in a specified repository. For more information, see data backup and restoration.

Syntax

SHOW SNAPSHOT ON <repo_name>
[WHERE SNAPSHOT = <snapshot_name> [AND TIMESTAMP = <backup_timestamp>]]

Parameters

ParameterDescription
repo_nameName of the repository that the snapshot belongs to.
snapshot_namName of the snapshot.
backup_timestampBackup timestamp of the snapshot.

Return

ReturnDescription
SnapshotName of the snapshot.
TimestampBackup timestamp of the snapshot.
StatusDisplays OK if the snapshot is okay. Displays error message if the snapshot is not okay.
DatabaseName of the database that the snapshot belongs to.
DetailsJSON-formatted directory and structure of the snapshot.

Example

Example 1: Views snapshots in repository example_repo.

SHOW SNAPSHOT ON example_repo;

Example 2: Views the snapshot named backup1 in repository example_repo.

SHOW SNAPSHOT ON example_repo
WHERE SNAPSHOT = "backup1";

Example 3: Views the snapshot named backup1 with backup timestamp 2018-05-05-15-34-26 in repository example_repo.

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