Skip to content

CREATE SNAPSHOT

Syntax Description

The CREATE SNAPSHOT command is used to create snapshots. An instance can only create snapshots for this instance, and the snapshots created are only visible to this instance.

Syntax Structure

> CREATE SNAPSHOT snapshot_name FOR ACCOUNT account_name

Example

--Execute under instance 585b49fc_852b_4bd1_b6d1_d64bc1d8xxxx
create snapshot sp1 for account `585b49fc_852b_4bd1_b6d1_d64bc1d8d485`;

mysql> show snapshots;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| SNAPSHOT_NAME | TIMESTAMP | SNAPSHOT_LEVEL | ACCOUNT_NAME | DATABASE_NAME | TABLE_NAME |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| sp1 | 2024-07-09 06:34:09.381035637 | account | 585b49fc_852b_4bd1_b6d1_d64bc1d8xxxx | | |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.16 sec)

limit

  • Currently, only instance-level snapshots are supported, and cluster-level, database-level, and table-level snapshots are not supported.