数据库自动备份到云服务器

import subprocess
import datetime
import os
from qcloud_cos import CosConfig
from qcloud_cos import CosS3Client

# 腾讯云COS配置
secret_id = 'YOUR_SECRET_ID'
secret_key = 'YOUR_SECRET_KEY'
region = 'ap-guangzhou'
bucket_name = 'YOUR_BUCKET_NAME'

config = CosConfig(Region=region, SecretId=secret_id, SecretKey=secret_key)
client = CosS3Client(config)

# MySQL备份配置
db_host = 'localhost'
db_user = 'root'
db_password = 'password'
db_name = 'test_db'

def backup_database():
    timestamp = datetime.datetime.now().strftime('%Y%m%d%H%M%S')
    backup_file = f'{db_name}_{timestamp}.sql'
    
    # 执行mysqldump命令进行备份
    command = f'mysqldump -h {db_host} -u {db_user} -p{db_password} {db_name} > {backup_file}'
    subprocess.run(command, shell=True, check=True)
    
    # 上传备份文件到腾讯云COS
    with open(backup_file, 'rb') as f:
        response = client.put_object(
            Bucket=bucket_name,
            Body=f,
            Key=backup_file
        )
        print(f'Backup file {backup_file} uploaded successfully: {response}')

if __name__ == '__main__':
    backup_database()