Creating a Manual Backup for GaussDB Tables
Scenarios
GaussDB allows you to create table-level manual backups for available instances. You can use these backups to restore data for ensuring data reliability.
Precautions
- You can back up data of instances that are in the Available state.
- A user can perform only one table-level backup operation for a DB instance at a time.
- Keep your account balance above zero so that table-level backups can be created.
- Tables in the postgres, template0, template1, templatea, and templatepdb system databases cannot be backed up using the table-level backup method.
- Tables in M-compatible databases cannot be backed up using the table-level backup method.
- Tables in system schemas (for example, public) cannot be backed up using the table-level backup method.
By default, public is a system schema. However, you can run commands to change the owner of public. When the owner is changed to a non-system user, you can back up tables in the public schema.
- When a DB instance is deleted, the automated backups for tables are also deleted, but manual table backups are retained.
Billing
Backups are saved as packages in OBS buckets. For the billing details, see How Is GaussDB Backup Data Charged?
After a DB instance is deleted, the free backup space of the DB instance is automatically canceled. Manual backups are billed based on the space required. For details, see Product Pricing Details.
Procedure
- Log in to the management console.
- Click
in the upper left corner and select a region and project.
- Click
in the upper left corner of the page and choose .
- On the Instances page, click the name of the target instance to go to the Basic Information page.
- In the navigation pane on the left, choose Backups. On the displayed page, click Table Backup under Full Backups and click Create Backup.
- Enter the backup name and description, select the required data and click Create Backup.
- The backup name is case-sensitive and can contain 4 to 64 characters. It must start with a letter. Only letters, digits, hyphens (-), and underscores (_) are allowed.
- The description can contain up to 256 characters, but cannot contain carriage returns and the following special characters: >!<"&'=
- During the creation process, the status is Creating. The time required for creating a manual backup depends on the data volume.
- View and manage the created backup on the current page.
Alternatively, go back to the instance list page, and click Backups to view and manage the backup.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot