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

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Data Source. On the Data Source page, select a region in the upper-left corner.
    Select a region
  3. Click Batch backup.
    Batch backup
  4. 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.

    Data source type
    Note For more information, see Backup methods.
  5. In the Data Source step, select the data sources that you want to back up and click NextBackup Object.
    Data Source
    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.
  6. 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.
    Backup Object
    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.
  7. Click NextBackup Configuration.
  8. In the Backup Configuration step, select a backup schedule specification, modify the backup configurations, and then click NextBackup Strategy.
    1. Click Select the specifications. In the dialog box that appears, select a backup schedule specification and click OK.
      Select the specifications.
      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.
    2. 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.
  9. 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.
    Backup Strategy
    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.
  10. 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.
    Purchase Schedule

    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.

    Precheck
    Note The precheck takes about 2 minutes. A larger data source requires more time. Click Precheck Progress to view the precheck progress.
  11. Click Turn on backup.
    Complete

    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.

    Data source details