本地文件保存至mysql

import mysql.connector
from mysql.connector import Error

def save_file_to_mysql(file_path, table_name):
    try:
        # 连接到MySQL数据库
        connection = mysql.connector.connect(
            host='localhost',
            database='your_database',
            user='your_username',
            password='your_password'
        )

        if connection.is_connected():
            cursor = connection.cursor()

            # 读取文件内容
            with open(file_path, 'rb') as file:
                file_content = file.read()

            # 插入文件内容到数据库
            query = f"INSERT INTO {table_name} (file_name, file_content) VALUES (%s, %s)"
            cursor.execute(query, (file_path, file_content))

            # 提交事务
            connection.commit()
            print(f"File {file_path} saved to MySQL successfully.")

    except Error as e:
        print(f"Error: {e}")

    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

# 使用示例
save_file_to_mysql('path/to/your/file.txt', 'your_table_name')