python实现mysql数据库自动备份

import os
import time
import pymysql
from datetime import datetime

# 数据库连接信息
db_host = 'localhost'
db_user = 'username'
db_password = 'password'
db_name = 'database_name'
backup_folder = 'your_backup_folder_path'

# 连接数据库
connection = pymysql.connect(host=db_host, user=db_user, password=db_password, database=db_name)
cursor = connection.cursor()

# 获取当前时间
now = datetime.now().strftime('%Y-%m-%d_%H-%M-%S')

# 创建备份文件名
backup_file = f"{backup_folder}/{db_name}_{now}.sql"

# 执行备份命令
os.system(f"mysqldump -u {db_user} -p{db_password} {db_name} > {backup_file}")

# 关闭数据库连接
cursor.close()
connection.close()