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()

# 获取最新的备份文件
backup_files = [f for f in os.listdir(backup_folder) if f.endswith('.sql')]
latest_backup_file = max(backup_files, key=lambda x: os.path.getctime(os.path.join(backup_folder, x)))

# 执行恢复命令
os.system(f"mysql -u {db_user} -p{db_password} {db_name} < {os.path.join(backup_folder, latest_backup_file)}")

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