Database Backup (DBS) provides the batch backup feature that allows you to back up one or more databases. This topic describes how to back up one or more databases. In this example, logical backups of MySQL databases are configured.

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.
  3. Click Batch backup.
    Batch backup
  4. In the dialog box that appears, configure Data source type and Backup Method, and then click Start Batch Backup.

    In the Data Source dialog box, all available data sources that meet the specified conditions are displayed.

    Data source type
  5. In the Data Source step, select the data sources that you want to back up and click Next Select Backup Objects.
    Data Source
    Note
    • You can select one or more databases in this step. The batch backup feature does not allow you to select data sources across 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 backup operations.
    • 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 username and password are not configured for the data source that you want to back up, you must configure the username 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. Click Next Configure Backup Settings.
    Backup Object
    Note
    • When 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. In the Backup Configuration step, select a backup schedule specification, modify the backup configurations, and then click Next Configure Backup Policy.
    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 backup schedule specifications.
    2. Click Modify the backup configuration in bulk. In the dialog box that appears, modify the following parameters and click OK.
      Section 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 in the console.
      Real-Time Transaction Log 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.
  8. In the backup policy 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 Next Purchase Backup 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 policy templates.
    • To modify a backup policy, you can click Select an option in the Backup Strategy column.
  9. In the Purchase Schedule step, check the order information, read and select service terms, and then select Auto-renewal at expiration based on your needs. Click Batch order, and then complete the payment.
    Purchase Schedule

    After the payment is successful, the system starts to configure the backup schedule and performs a precheck. During the precheck, the system initializes the backup schedule and checks the configuration environment.

    Precheck
    Note The precheck takes about 1 to 2 minutes. The larger the data source, the more the time a precheck requires to complete. Click Precheck Progress to view the precheck progress.
  10. After the precheck is successful, click Complete.
    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

What to do next