修改 my.ini 文件为文后内容

根据自己 MySQL 安装目录来设置
basedir=“D:/mysql-5.7.38-winx64/”
datadir=“D:/mysql-5.7.38-winx64/data/”

关闭严格模式

innodb_strict_mode=0

日期相关的配置

sql_mode=NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO

导入完成后再给这两个配置注释掉

[mysqld]
innodb_strict_mode=0
sql_mode=NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
basedir="D:/mysql-5.7.38-winx64/"
datadir="D:/mysql-5.7.38-winx64/data/"
port=3306

max_allowed_packet = 5000M
key_buffer_size= 3840M

sort_buffer_size = 32M
read_buffer_size = 32M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 256M
thread_cache_size = 32
query_cache_size = 256M
interactive_timeout=1814400
wait_timeout=1814400

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB