tencent cloud

All product documents
TDSQL-C for MySQL
DocumentationTDSQL-C for MySQLOperation GuideBackup and RestorationPerforming BackupManual Backup
Manual Backup
Download PDF
Last updated: 2024-09-11 17:15:02
Manual Backup
Last updated: 2024-09-11 17:15:02
Download PDF
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 window, select the backup type and object, set the backup file alias, and click OK.

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 instance, while logical backup applies to the entire instance or specified databases/tables.
Alias
You can set a file alias when creating a manual backup, which can contain up to 60 digits, letters, or symbols (-_./()[]+=:;@).
Cross-Region Backup
Manual logical backup (entire cluster) allows you to choose whether to enable cross-region backup.
Once enabled, the manual logical backup (entire cluster) 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
When enabling cross-region backup, you can choose up to three different regions to store the manual logical backup (entire cluster) files.
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.


Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon