怎么导出mysql的数据库表结构

mysqldump -u [username] -p --no-data [database_name] > [output_file.sql]

mysqldump -u root -p --no-data mydatabase > mydatabase_structure.sql

import mysql.connector

def export_table_structure(host, user, password, database, output_file):
    try:
        # 连接到MySQL数据库
        conn = mysql.connector.connect(host=host, user=user, password=password, database=database)
        cursor = conn.cursor()

        # 获取所有表的名称
        cursor.execute("SHOW TABLES")
        tables = cursor.fetchall()

        with open(output_file, 'w') as file:
            for table in tables:
                table_name = table[0]
                cursor.execute(f"SHOW CREATE TABLE {table_name}")
                create_table_sql = cursor.fetchone()[1]
                file.write(f"{create_table_sql};\n\n")

        print(f"Table structure exported to {output_file}")
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        if conn.is_connected():
            cursor.close()
            conn.close()

# 示例调用
export_table_structure('localhost', 'root', 'your_password', 'mydatabase', 'mydatabase_structure.sql')

conn = mysql.connector.connect(host=host, user=user, password=password, database=database, charset='utf8mb4')