怎么导入数据库到mysql数据库

CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    position VARCHAR(100)
);

INSERT INTO employees (name, position) VALUES ('John Doe', 'Developer');
INSERT INTO employees (name, position) VALUES ('Jane Smith', 'Designer');

mysql -u root -p
USE mydatabase;
SOURCE /home/user/data.sql;

id,name,position
1,"John Doe","Developer"
2,"Jane Smith","Designer"

LOAD DATA INFILE '/home/user/employees.csv'
INTO TABLE employees
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="username",
    password="password",
    database="database_name"
)

cursor = db.cursor()

# 执行SQL文件中的语句
with open('data.sql', 'r') as file:
    sql_script = file.read()
    for statement in sql_script.split(';'):
        if statement.strip():
            cursor.execute(statement)

db.commit()
cursor.close()
db.close()