往远程mysql传数据库

import mysql.connector
from mysql.connector import Error

def backup_database(host, database, user, password):
    try:
        connection = mysql.connector.connect(host=host, database=database, user=user, password=password)
        cursor = connection.cursor()
        cursor.execute("BACKUP DATABASE TO DISK = '/path/to/backup/file.bak'")
        print("Database backup completed successfully.")
    except Error as e:
        print(f"Error: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

def restore_database(host, database, user, password, backup_file):
    try:
        connection = mysql.connector.connect(host=host, database=database, user=user, password=password)
        cursor = connection.cursor()
        cursor.execute(f"RESTORE DATABASE FROM DISK = '{backup_file}'")
        print("Database restore completed successfully.")
    except Error as e:
        print(f"Error: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 示例用法
backup_database('source_host', 'source_database', 'user', 'password')
restore_database('target_host', 'target_database', 'user', 'password', '/path/to/backup/file.bak')