On this page

Show all

Help Center/ GaussDB/ User Guide/ Data Backup/ Backup Execution/ Creating a Manual Backup for GaussDB Tables

Creating a Manual Backup for GaussDB Tables

Updated on 2025-02-17 GMT+08:00

View PDF

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.

NOTE:

When a DB instance is deleted, the automated backups for tables are also deleted, but manual backups for tables are not deleted.

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.
NOTICE:

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.

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 Databases > GaussDB.
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 data to be backed up, and click Create Backup.
- The backup name must consist of 4 to 64 characters and start with a letter. It can contain only uppercase letters, lowercase letters, digits, hyphens (-), and underscores (_).
- 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.

Parent Topic: Backup Execution

Previous topic: Creating a Manual Backup for GaussDB Instances

Next topic: Backup Management

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot