Scenarios

GaussDB(for MySQL) allows you to create manual backups for available primary nodes. You can restore data from backups to ensure data reliability.

• When you delete a DB instance, its automated backups are also deleted but its manual backups are retained.

Method 1

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click Service List. Under Database, click GaussDB.
4. On the Instance Management page, locate the target DB instance and choose More > Create Backup in the Operation column.
5. In the displayed dialog box, enter a backup name and description. Then, click OK. If you want to cancel the backup creation task, click Cancel.
   • 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 must consist of a maximum of 256 characters and cannot contain the carriage return character or the following special characters: !<"='>&
   • The time required for creating a manual backup depends on the data volume of the DB instance.

   To check whether the backup has been successfully created, click in the upper right corner of the page to check the instance status. If the instance status is Available, the backup has been successfully created.

   Figure 1 Creating a manual backup
   

6. After a manual backup has been created, you can view and manage it on the Backup Management page.

   Alternatively, click the target DB instance. On the Backups & Restorations page, you can view and manage the manual backups.

Method 2

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click Service List. Under Database, click GaussDB.
4. On the Instance Management page, click the target DB instance.
5. On the Backups & Restorations page, click Create Backup. In the displayed dialog box, enter a backup name and a description, and click OK. If you want to cancel the backup creation task, click Cancel.
   • 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 must consist of a maximum of 256 characters and cannot contain the carriage return character or the following special characters: !<"='>&
   • The time required for creating a manual backup depends on the data volume of the DB instance.
   Figure 2 Creating a manual backup
   

6. After a manual backup has been created, you can view and manage it on the Backup Management page.

   Alternatively, click the target DB instance. On the Backups & Restorations page, you can view and manage the manual backups.