sql文件大无法导入mysql数据库

# 使用 split 命令分割文件
split -l 10000 large_file.sql small_file_

[mysqld]
max_allowed_packet=1G
innodb_buffer_pool_size=2G

mysql -u username -p database_name < large_file.sql

import mysql.connector

db = mysql.connector.connect(host="localhost", user="username", password="password", database="database_name")
cursor = db.cursor()

with open('large_file.sql', 'r') as file:
    batch_size = 1000
    batch = []
    for line in file:
        if line.strip().lower().startswith('insert'):
            batch.append(line)
            if len(batch) >= batch_size:
                cursor.execute("".join(batch))
                db.commit()
                batch = []
    if batch:
        cursor.execute("".join(batch))
        db.commit()

cursor.close()
db.close()