Manual Backup
Download
Focus Mode
Font Size
TDSQL-C for MySQL supports automatic backup and manual backup. This document describes how to create a manual backup in the console.
Note:
To ensure the stability of the backup system, the current system allows initiating a backup only once per hour.
With manual backup, you can use snapshot backup to manually back up the entire cluster or use logical backup to back up the entire cluster or specified databases/tables.
Logical backups in the manual backup can be manually deleted from the backup list to free up backup space and avoid space waste and occupancy. Snapshot backups do not support manual deletion.
Logical backups in the manual backup (entire cluster) supports enabling cross-region backup feature, allowing manual logical backup (entire cluster) CFS to other regions.
If your cluster storage space usage exceeds 2TB, it is not recommended to use the logical backup due to the risk of backup failure.
Directions
1. Log in to the TDSQL-C for MySQL console.
2. Select the region at the top, find the target cluster in the cluster list, and click the cluster ID or Manage in the Operation column to enter the cluster management page.
3. On the cluster management page, select the Backup Management tab and click Manual Backup.
4. In the pop-up dialog box, complete the following configurations and click OK to create a backup task.
Parameter | Description |
Backup Type | Snapshot Backup and Logical Backup are supported. Note: We recommend you perform a manual logical backup task during off-peak hours, as it will lock the database and affect database use. |
Object | Snapshot Backup applies to the Entire cluster, while Logical Backup applies to the Entire cluster or Specify Table. If you select Specify Table, you can choose specific databases and tables for manual backup. |
Cross-Region Backup | You can choose whether to enable cross-region backup for Snapshot Backup (for the Entire cluster) and Logical Backup (for the Entire cluster). If this is enabled, backup files can be saved to other regions. If not enabled, the reserved region for the manual logical backup is the current cluster's region by default. |
Backup Region | If Cross-Region Backup is enabled, you can select up to three different regions to store the backup files. |
Store to Vault | If this option is enabled, manual backups will be delivered to the backup vault for storage. For details on the backup vault, see Backup Vault. Note: Manual snapshot backups for the entire cluster, manual logical backups for the entire cluster, and manual logical backups for specified databases and tables all support the "Store to Vault" parameter. |
Select Vault | If "Store to Vault" is enabled, you can select the target backup vault for storage. |
Alias | When you create a manual backup, you can set an alias for the backup file. The alias can contain only digits, uppercase and lowercase letters, Chinese characters, and special characters (-_./()[]（）+=：;@), with a maximum length of 60 digits. |
5. After creating a manual backup task, you can view the task progress in the Task List on the left sidebar. You can also view the execution status by clicking Backup Details in the Operation column.
Related APIs
API | Description |
This API (CreateBackup) is used to create a manual backup for a cluster. |
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback