mysql导出数据库的函数

mysqldump --single-transaction -u username -p database_name > backup.sql

mysqldump --ignore-table=db_name.sensitive_table -u username -p db_name > backup.sql

mysqldump --compatible=mysql40 -u username -p db_name > backup.sql

import mysql.connector
from mysql.connector import Error

def export_database(host, database, user, password, output_file):
    try:
        connection = mysql.connector.connect(host=host,
                                             database=database,
                                             user=user,
                                             password=password)
        if connection.is_connected():
            cursor = connection.cursor()
            dump_command = f"mysqldump --user={user} --password={password} {database} > {output_file}"
            cursor.execute(dump_command)
            print(f"Database exported to {output_file}")
    except Error as e:
        print(f"Error: {e}")
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 示例调用
export_database('localhost', 'mydatabase', 'myuser', 'mypassword', 'backup.sql')