mysql数据库ftp备份

import ftplib
import subprocess
import datetime

# FTP服务器配置
ftp_host = 'ftp.example.com'
ftp_user = 'user'
ftp_pass = 'password'
ftp_dir = '/backups'

# MySQL配置
mysql_host = 'localhost'
mysql_user = 'root'
mysql_pass = 'password'
mysql_db = 'mydatabase'

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

# 执行mysqldump命令备份数据库
dump_cmd = f'mysqldump -h {mysql_host} -u {mysql_user} -p{mysql_pass} {mysql_db} > {backup_file}'
subprocess.run(dump_cmd, shell=True, check=True)

# 连接FTP服务器并上传备份文件
with ftplib.FTP(ftp_host, ftp_user, ftp_pass) as ftp:
    ftp.cwd(ftp_dir)
    with open(backup_file, 'rb') as f:
        ftp.storbinary(f'STOR {backup_file}', f)

print(f'Backup completed: {backup_file}')