数据库备份工具源码

import pymysql
import os
import datetime

def backup_database(host, user, password, database, backup_path):
    # 连接数据库
    conn = pymysql.connect(host=host, user=user, password=password, database=database)
    cursor = conn.cursor()

    # 获取当前时间作为备份文件名
    timestamp = datetime.datetime.now().strftime('%Y%m%d%H%M%S')
    backup_file = os.path.join(backup_path, f'{database}_backup_{timestamp}.sql')

    # 执行mysqldump命令进行数据库备份
    os.system(f'mysqldump -h{host} -u{user} -p{password} {database} > {backup_file}')

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

    print(f'Database backup completed. Backup file saved at: {backup_file}')

# 使用示例
backup_database('localhost', 'root', 'password', 'testdb', '/path/to/backup')