### 调用腾讯云API接口下载对应的自动备份 Limit 1 ####
Editor: Martin Lee
DateTime: 2020/07/29
PS:本目录为下载腾讯云备份的历史数据,脚本与备份策略有一定的依赖关系,如果备份策略修改,对应的备份脚本的Limit 参数也许调整:
########################
# -*- coding: utf-8 -*-
import os
import sys
import time
import json
#import urllib, urllib.request
from tencentcloud.common import credential
from tencentcloud.common.profile.client_profile import ClientProfile
from tencentcloud.common.profile.http_profile import HttpProfile
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
import requests
# 导入对应产品模块的 client models。
from tencentcloud.cdb.v20170320 import cdb_client, models
def download_file(url,dst):
"""
url: 地址
dst: 绝对路径
"""
#url = "http://127.0.0.1:5001/video"
res = requests.get(url, stream=True)
with open(dst, 'wb') as f:
for chunk in res.iter_content(1024*1024*5):
f.write(chunk)
print '下载完成...'
try:
cred = credential.Credential("AKIDlSwFsNb09x0B3", "na9RamgFVTEDx")
httpProfile = HttpProfile()
httpProfile.endpoint = "cdb.ap-guangzhou.tencentcloudapi.com"
clientProfile = ClientProfile()
clientProfile.httpProfile = httpProfile
client = cdb_client.CdbClient(cred, "ap-guangzhou", clientProfile)
req = models.DescribeBackupsRequest()
params = '{\"InstanceId\":\"cdb-qwx1\"}'
req.from_json_string(params)
resp = client.DescribeBackups(req)
item = resp.Items
filename = item[0].Name
print(filename)
fileurl = item[0].InternetUrl
print(fileurl)
# Start Download
url = "https://mysql-databa1596032206%26q-key-time%3D1595989006%3B1596032206%26q-header-list%3D%26q-url-param-list%3D%26q-signature%3Dc481b289e88b599b7f14984802265135fa74310b&response-content-disposition=attachment%3Bfilename%3D%22MyDB-Changeodds-RW_backup_20200721020508.xb%22&response-content-type=application%2Foctet-stream"
localfile = '/data/backup.xb'
#urllib.request.urlretrieve(fileurl,localfile)
download_file(url,localfile)
except TencentCloudSDKException as err:
print(err)
###########################
本文介绍了如何使用Python脚本调用腾讯云API,从腾讯云数据库服务中下载MySQL的自动备份文件。通过示例代码展示了如何设置凭证、配置HTTP Profile和Client Profile,以及获取并下载备份文件。
1215

被折叠的 条评论
为什么被折叠?



