All Products
Search
Document Center

ApsaraDB RDS:Back up individual databases and tables

Last Updated:Oct 27, 2023

This topic describes how to back up individual databases or tables of an ApsaraDB RDS for MySQL instance.

Automatically back up individual databases and tables

  • ApsaraDB RDS: For data security purposes, ApsaraDB RDS provides the automatic backup feature to back up all the databases and tables of your RDS instance. The automatic backup feature cannot be used to directly back up individual databases or tables. If you do not need to back up some databases or tables, we recommend that you delete these databases and tables or migrate them to your computer.

  • Database Backup (DBS): DBS provides the logical backup feature to support the automatic backup of individual databases and tables. For more information, see Back up an ApsaraDB RDS for MySQL or self-managed MySQL instance by using logical backup.

Note

Manually back up individual databases and tables

A manual backup indicates that you manually create a backup file.

Use ApsaraDB RDS to perform backups

Prerequisites

  • If this is the first time you use the backup feature of ApsaraDB RDS, you must attach the AliyunServiceRoleForDBS policy by using your Alibaba Cloud account. For more information, see How do I create a service-linked role for DBS?

  • Your RDS instance meets the following requirements:

    • The RDS instance runs MySQL 8.0, MySQL 5.7, or MySQL 5.6.

    • The RDS instance runs RDS High-availability Edition or runs MySQL 5.7 on RDS Enterprise Edition.

    • The RDS instance uses local disks.

Note

You can go to the Basic Information page of your RDS instance to obtain the preceding information.

Usage notes

If your RDS instances run RDS High-availability Edition with local disks, you can back up only specified databases but not specified tables. For more information, see Storage types.

Note

RDS instances that use cloud disks support only snapshot backups. You cannot back up individual databases or tables of the RDS instances.

Procedure

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the upper-right corner of the page that appears, click Backup Instance.

  3. In the dialog box that appears, set the Select Backup Mode parameter to Logical Backup and the Backup Policy parameter to Single-Database Backup.

    image.png
  4. Select the databases that you want to back up and click the 右移 icon to move the selected databases to the right-side section. Then, click OK.

  5. Optional. View the progress of the backup task.

    The system generates a logical backup task. You can click the 查看备份进度 icon in the upper-right corner of the page. On the Tasks page, set the Task Type parameter to Manual Backup to view the backup progress.

    image.png
  6. Optional. Restore the backup data.

    You can restore the data of your RDS instance from the generated logical backup file. For more information, see Restore the data of an ApsaraDB RDS for MySQL instance from a logical backup file to a self-managed MySQL instance and Restore individual databases and tables of an ApsaraDB RDS for MySQL instance.

Use DBS to perform backups

  1. Create a backup schedule. Make sure that you select the logical backup method. For more information, see Purchase a backup schedule.

  2. Configure a backup schedule and select Single Backup for the backup schedule. For more information, see Configure a backup schedule.

    For more information, see Back up an ApsaraDB RDS for MySQL or self-managed MySQL instance by using logical backup.

Related operations

Category

Operation

Description

ApsaraDB RDS

ModifyBackupPolicy

Modifies the backup settings of an instance.

DescribeBackupPolicy

Queries the backup settings of an instance.

DescribeBackups

Queries the backup sets of an instance.

DescribeBackupTasks

Queries the backup tasks of an instance.

DBS

CreateBackupPlan

Creates a backup plan.

ConfigureBackupPlan

Configures a backup plan.