python备份mysql数据库表

import mysql.connector
import datetime

# MySQL数据库连接配置
config = {
    'user': 'username',
    'password': 'password',
    'host': 'hostname',
    'database': 'database_name',
}

# 备份指定的数据库表
def backup_table(table_name):
    # 创建数据库连接
    conn = mysql.connector.connect(**config)
    cursor = conn.cursor()

    try:
        # 获取当前时间作为备份文件名
        now = datetime.datetime.now()
        backup_file = f'{table_name}_{now.strftime("%Y%m%d%H%M%S")}.sql'

        # 执行备份操作
        cursor.execute(f'SELECT * INTO OUTFILE "{backup_file}" FROM {table_name}')
        conn.commit()

        print(f'{table_name}表备份成功，备份文件名：{backup_file}')
    except Exception as e:
        print(f'{table_name}表备份失败：{str(e)}')
    finally:
        # 关闭数据库连接
        cursor.close()
        conn.close()

# 调用备份函数
backup_table('table_name')