XML 数据导入 MySQL

MySQL verison: 8.0.13
XML 文件大小：65,146,062KB

新建table

USE dataBaseName;
CREATE TABLE tableName(
	Id INT NOT NULL PRIMARY KEY,
	...
	Title text NULL,
	...
	Count INT NULL
);

数据库的字段和XML 文件中的字段一一对应（注意大小写）。

导入XML

对于老版本MySQL：

use databasename;
LOAD XML LOCAL INFILE '/pathtofile/file.xml' INTO TABLE my_tablename;

对于新版本MySQL:

# add blow config to my.ini file:
loose-local-infile = 1
secure_file_priv=''

# Start the MySQL with --local-infile parameter
mysql -u userName -p --local-infile

# I fail below commands in MySQL Workbench, but success in CMD with admin. 
# Recommend use below commands in CMD
USE so;
LOAD XML INFILE '/pathtofile/file.xml'
INTO TABLE tableName
ROWS IDENTIFIED BY '<tag>';