python mysql自动备份

import subprocess
import datetime
import os

# 配置参数
DB_USER = 'your_db_user'
DB_PASSWORD = 'your_db_password'
DB_NAME = 'your_db_name'
BACKUP_DIR = '/path/to/backup/directory'

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

# 执行备份命令
backup_command = f'mysqldump -u {DB_USER} -p{DB_PASSWORD} {DB_NAME} > {BACKUP_DIR}/{backup_file}'
subprocess.run(backup_command, shell=True)

# 压缩备份文件
compress_command = f'gzip {BACKUP_DIR}/{backup_file}'
subprocess.run(compress_command, shell=True)

print(f'Backup completed: {BACKUP_DIR}/{backup_file}.gz')