如何把数据库备份到云服务器

import subprocess
import paramiko

# 数据库配置
db_host = 'localhost'
db_user = 'root'
db_password = 'password'
db_name = 'mydatabase'

# 云服务器配置
cloud_host = 'your_cloud_server_ip'
cloud_user = 'your_cloud_server_user'
cloud_password = 'your_cloud_server_password'
cloud_backup_path = '/path/to/cloud/backup'

# 执行本地数据库备份
local_backup_file = f'{db_name}_backup.sql'
subprocess.run(f'mysqldump -h {db_host} -u {db_user} -p{db_password} {db_name} > {local_backup_file}', shell=True)

# 使用SSH上传备份文件到云服务器
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect(cloud_host, username=cloud_user, password=cloud_password)
sftp = ssh.open_sftp()
sftp.put(local_backup_file, f'{cloud_backup_path}/{local_backup_file}')
sftp.close()
ssh.close()

print(f'Backup completed and uploaded to {cloud_backup_path}')