mysql批处理无法备份

import mysql.connector
from mysql.connector import Error

def backup_database(host, database, user, password, tables):
    try:
        connection = mysql.connector.connect(host=host,
                                             database=database,
                                             user=user,
                                             password=password)
        if connection.is_connected():
            cursor = connection.cursor()
            backup_file = "backup.sql"
            with open(backup_file, 'w') as f:
                for table in tables:
                    cursor.execute(f"SELECT * FROM {table}")
                    rows = cursor.fetchall()
                    for row in rows:
                        f.write(f"INSERT INTO {table} VALUES {row};\n")
            print(f"Backup completed successfully. File saved as {backup_file}")
    except Error as e:
        print(f"Error: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 示例调用
backup_database('localhost', 'database_name', 'username', 'password', ['table1', 'table2', 'table3'])