python备份mysql

import os
import subprocess

# 数据库连接信息
db_host = 'localhost'
db_user = 'root'
db_pass = 'password'
db_name = 'my_database'

# 备份文件名
backup_file = 'backup.sql'

# 备份命令
backup_cmd = f'mysqldump -h {db_host} -u {db_user} -p{db_pass} {db_name} > {backup_file}'

# 执行备份命令
subprocess.call(backup_cmd, shell=True)

# 上传备份文件到腾讯云COS
cos_bucket = 'my-bucket'
cos_region = 'ap-guangzhou'
cos_secret_id = 'your-secret-id'
cos_secret_key = 'your-secret-key'
cos_backup_file = f'cos://{cos_bucket}.cos.{cos_region}.myqcloud.com/{backup_file}'
cos_upload_cmd = f'coscmd config -a {cos_secret_id} -s {cos_secret_key} -r {cos_region} && coscmd upload {backup_file} {cos_backup_file}'
subprocess.call(cos_upload_cmd, shell=True)

# 删除本地备份文件
os.remove(backup_file)