mysql异地自动备份

import subprocess
import datetime
import os

# 配置参数
db_host = 'localhost'
db_user = 'your_username'
db_password = 'your_password'
db_name = 'your_database'
backup_dir = '/path/to/backup/directory'
remote_host = 'remote_server_ip'
remote_user = 'remote_username'
remote_password = 'remote_password'
remote_dir = '/path/to/remote/backup/directory'

# 创建备份目录
if not os.path.exists(backup_dir):
    os.makedirs(backup_dir)

# 生成备份文件名
timestamp = datetime.datetime.now().strftime('%Y%m%d%H%M%S')
backup_file = f'{db_name}_{timestamp}.sql'

# 执行mysqldump命令
dump_command = f'mysqldump -h {db_host} -u {db_user} -p{db_password} {db_name} > {backup_dir}/{backup_file}'
subprocess.run(dump_command, shell=True, check=True)

# 将备份文件传输到远程服务器
scp_command = f'scp {backup_dir}/{backup_file} {remote_user}@{remote_host}:{remote_dir}'
subprocess.run(scp_command, shell=True, check=True)

# 删除本地备份文件（可选）
os.remove(f'{backup_dir}/{backup_file}')