All Products
Search
Document Center

Database Backup:Manually download a backup set

Last Updated:Nov 30, 2023

If you want to restore a backup set to an on-premises database or if you want to save a backup file to on-premises storage or an Excel file for analysis and auditing, you can manually download the backup set. This topic describes how to manually download a backup set.

Limits

LimitLogical backupPhysical backup
Backup destination storage typeOnly DBS built-in storage is supported. Object Storage Service (OSS) buckets are not supported. Only DBS built-in storage is supported. Object Storage Service (OSS) buckets are not supported.
Full dataThe following database engines are supported:
  • MySQL
  • SQL Server
  • MariaDB
  • PostgreSQL
  • PPAS
  • Oracle
  • MongoDB
Note MongoDB data is in the JSON format. Other data is in the CSV format.
The following database engines are supported:
  • MySQL
  • SQL Server
Note
  • MySQL data is in the same format as the data in Percona XtraBackup and is compressed.
  • SQL Server data is in the same format as the data generated by the native backup command and is compressed.
Incremental dataThe following database engines are supported:

MySQL

Note Data is in the native format of MySQL.
The following database engines are supported:
  • MySQL
  • SQL Server
Note Backup data is in the same format as its full data.

Pricing

Database Backup (DBS) does not charge a fee for network traffic that is generated when you manually download a backup set.

Procedure

  1. Log on to the Database Backup (DBS) console.

  2. In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.

  3. Find the backup schedule that you want to manage and click the schedule ID or Manage in the Actions column.

    管理按钮

  4. In the left-side navigation pane of the page that appears, choose Backup Tasks > Full Data.

    Note
    • If database engines allow you to download incremental backup data and incremental log backup is enabled for backup schedules, you can also download incremental log backup sets. For more information, see Database engines and features or Backup and restoration overview.

    • You can download Transaction Log Backup sets by using a similar method. You can choose Backup Tasks > Transaction Log Backup and perform subsequent operations.

  5. Find the backup set that you want to download and click Download in the Actions column.

    备份集下载按钮

  6. In the message that appears, click OK.

    After you click OK, the system packages, compresses, and converts backup files into downloadable files. The Backup Set Download details page appears.

    Note

    The time that is consumed to compress and convert a backup file varies based on the size of the backup file. A larger backup file takes longer to compress and convert. For example, it takes approximately 4 hours to compress and convert a backup file that has 150 GB of data.

  7. After Completed is displayed in the Status column of the backup set to be downloaded, click Download in the Actions column.

    下载按钮2

  8. In the message that appears, click I see. Downloads. Alternatively, you can download the backup set to your local computer by using the public or internal endpoint of the backup set.

  9. After the download is complete, decompress the downloaded package. By default, the backup set is compressed in the <Download task ID>.tar.gz package.

    Run the following commands to decompress the downloaded package:

    1. Run the gzip -d <Download task ID>.tar.gz command to obtain the <Download task ID>.tar file.

    2. Run the file <Download task ID>.tar command to view the file format after the gzip command is run:

      • If the file format is POSIX tar archive, run the tar xvf <Download task ID>.tar command to obtain the <Download task ID> file.

      • If the file format is Zip archive data, at least v2.0 to extract, run the unzip <Download task ID>.tar command to obtain the <Download task ID> file.

    3. Optional. If an XB file exists after you perform the preceding steps, you must download the tool and run the following commands to decompress the file.

      • Windows

        Run the xbunpack.exe -file=<Download task ID>.xb -dir=<Destination storage directory> command to decompress the file.

      • Linux

        Method 1: Run the xbunpack -file=<Download task ID>.xb -dir=<Destination storage directory> command to decompress the file.

        Method 2: Run the cat <Download task ID>.xb | ./xbunpack -dir=<Destination storage directory> command to decompress the file.

      Download xbunpack.exe for Windows or xbunpack for Linux.