Database Backup (DBS) provides the batch backup feature, which allows you to back up one or more databases. This topic describes
how to back up one or more databases. Logical backups of MySQL databases are configured
in this example.
Precautions
- Before you back up one or more databases, you must add one or more data sources. You
can use one of the following methods to add data sources:
- You can use the batch backup feature only for the databases that use the same database
engine and backup method. For example, you can perform logical backups on multiple
MySQL databases at a time. You can also perform physical backups on multiple Oracle
databases at a time.
Procedure
- Log on to the DBS console.
- In the left-side navigation pane, click Data Source. On the Data Source page, select a region in the upper-left corner.
- Click Batch backup.
- Configure Data source type and Backup Method, and then click Start Batch Backup.
The system lists the available data sources that meet the specified conditions.
- In the Data Source step, select the data sources that you want to back up and click NextBackup Object.

Note
- You can select a single database in this step.
- The batch backup feature does not allow you to select data sources across multiple
pages. By default, 20 data sources are displayed on each page. If you need to back
up more than 20 data sources, we recommend that you perform multiple batch backups.
- To search for a data source, you can enter the name of the data source in the search
box. You can also filter the data source based on the logical group to which the data
source belongs.
- If the database account and password are not configured for the data source that you
want to back up, you must configure the account and password. For more information,
see Configure the account and password for a data source.
- In the Backup Object step, select the data sources that you want to add. Select the databases and tables
that you want to back up and click the right arrow to move these databases and tables
from the Available section to the Selected section.

Note
- If you back up an entire database instance, the permission data and stored procedures
are also backed up.
- You can click One-click backup to back up all databases and tables in the database instance.
- Click NextBackup Configuration.
- In the Backup Configuration step, select a backup schedule specification, modify the backup configurations, and
then click NextBackup Strategy.
- Click Select the specifications. In the dialog box that appears, select a backup schedule specification and click
OK.

Note
- The backup schedule specification that you select applies to all data sources that
you add in this batch backup. You cannot select a backup schedule specification for
each data source.
- The free quota for data backup, unit price, and backup and restoration performance
vary based on backup schedule specifications. For more information, see Select an instance type.
- Click Modify the backup configuration in bulk. In the dialog box that appears, modify the following parameters and click OK.
Category |
Parameter |
Description |
The underlying configuration |
maximum number of parallel threads for a full backup |
The maximum number of concurrent threads available for a full data backup.
Note The maximum number of actual concurrent threads varies based on backup schedule specifications.
|
Incremental log real-time backup |
Specifies whether to enable incremental backup. |
Advanced configuration |
None |
None |
Note To modify the backup configurations, you can also click Modify the backup configuration in the Actions column.
- In the Backup Strategy step, click Batch apply backup strategies. In the dialog box that appears, select a backup policy that you want to apply and
click OK. Then, click NextPurchase Schedule.

Note
- A backup policy contains configuration items for a backup schedule, such as the backup
method, storage method, backup frequency, backup cycle, and backup start time. For
more information, see Manage backup strategy.
- To modify a backup policy, you can click Select an option in the Backup Strategy column.
- In the Purchase Schedule step, check the order information, read and select service terms, and then select
Auto-renewal at expiration. Click Batch order, and then complete the payment.

After the payment is successful, the system starts to configure the backup schedule
and perform a precheck. A precheck includes initializing the backup schedule and checking
the configuration environment.

Note The precheck takes about 2 minutes. A larger data source requires more time. Click
Precheck Progress to view the precheck progress.
- Click Turn on backup.
After you click Complete, the system automatically starts the backup schedule. You
can view the created backup schedule on the details page of the destination instance.
