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
Limit | Logical backup | Physical backup |
---|---|---|
Backup destination storage type | Only 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 data | The following database engines are supported:
Note MongoDB data is in the JSON format. Other data is in the CSV format. | The following database engines are supported:
Note
|
Incremental data | The following database engines are supported: MySQL Note Data is in the native format of MySQL. | The following database engines are supported:
Note Backup data is in the same format as its full data. |
Pricing
DBS does not charge a fee for network traffic that is generated when you manually download a backup set.
Procedure
- Log on to the DBS console.
- In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
- Click the schedule ID or Manage in the Actions column corresponding to a backup schedule.
- In the left-side navigation pane of the Configure Task page, choose . 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.
- You can download incremental log backup sets by using a similar method. You can choose and perform subsequent operations.
- Click Download in the Actions column corresponding to a backup set ID.
- In the message that appears, click OK. Note
- After you click OK, the system packages, compresses, and converts backup files into downloadable files. The Backup Set Download details page appears.
- The time that is consumed to compress and convert a backup file varies with the size of the backup file. The larger the size of the backup file, the longer the time it takes. For example, it takes about 4 hours to compress and convert a backup file that has 150 GB of data.
- After Completed is displayed in the Status column corresponding to the backup set to be downloaded, click Download.
- 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.
- 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:- Run the
gzip -d <Download task ID>.tar.gz
command to obtain the<Download task ID>.tar
file. - 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 thetar 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 theunzip <Download task ID>.tar
command to obtain the<Download task ID>
file.
- If the file format is
- 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.
To download the tool, click xbunpack.exe (for Windows) or xbunpack (for Linux).
- Windows
- Run the