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
| Parameter | Description |
|---|---|
| repo_name | Name of the repository that the snapshot belongs to. |
| snapshot_nam | Name of the snapshot. |
| backup_timestamp | Backup timestamp of the snapshot. |
Return
| Return | Description |
|---|---|
| Snapshot | Name of the snapshot. |
| Timestamp | Backup timestamp of the snapshot. |
| Status | Displays OK if the snapshot is okay. Displays error message if the snapshot is not okay. |
| Database | Name of the database that the snapshot belongs to. |
| Details | JSON-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";