Updated on 2024-04-11 GMT+08:00

Creating a Manual Backup

Scenarios

RDS allows you to create manual backups of a running primary DB instance. You can use these backups to restore data.

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

Constraints

  • The number of tables in a DB instance affects the backup speed. The maximum number of tables is 250,000.
  • The system verifies the connection to the DB instance when starting a full backup task. If either of the following conditions is met, the verification fails and a retry is automatically performed. If the retry fails, the backup will fail.
    • DDL operations are being performed on the DB instance.
    • The backup lock failed to be obtained from the DB instance.

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 Relational Database Service. The RDS console is displayed.
  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 consists of a maximum of 256 characters and cannot contain carriage return characters or the following special characters: >!<"&'=
    • The time required for creating a manual backup depends on the amount of data.

  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 Relational Database Service. The RDS console is displayed.
  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 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 consists of a maximum of 256 characters and cannot contain carriage return characters or the following special characters: >!<"&'=
    • The time required for creating a manual backup depends on the amount of data.

  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.