mysql 云备份

import os
from tencentcloud.common import credential
from tencentcloud.common.profile.client_profile import ClientProfile
from tencentcloud.common.profile.http_profile import HttpProfile
from tencentcloud.mysql.v20170312 import mysql_client, models

# 设置腾讯云API密钥
secret_id = "your_secret_id"
secret_key = "your_secret_key"

# 初始化凭证信息
cred = credential.Credential(secret_id, secret_id)

# 初始化http选项
httpProfile = HttpProfile()
httpProfile.endpoint = "mysql.tencentcloudapi.com"

# 初始化client选项
clientProfile = ClientProfile()
clientProfile.httpProfile = httpProfile

# 初始化mysql客户端
client = mysql_client.MysqlClient(cred, "", clientProfile)

# 创建备份请求
req = models.CreateBackupRequest()
params = {
    "InstanceId": "your_instance_id",
    "BackupMethod": "logical",
    "BackupDBTableList": [
        {
            "Database": "your_database_name",
            "TableList": ["your_table_name"]
        }
    ]
}
req.from_json_string(params)

# 发送备份请求
resp = client.CreateBackup(req)
print(resp.to_json_string(indent=2))