mysql导入大文件报错

设置以下参数再进行导入

wait_timeout=2880000
interactive_timeout = 2880000
#修改max_allowed_package ，多大根据你的实际情况max_allowed_packet = 100M

-----关闭binlog------
 # 关闭mysql主从，关闭binlog
 vim /etc/my.cnf  //注释掉log-bin,binlog_format
 # Replication Master Server (default)
 # binary logging is required for replication
 # log-bin=mysql-bin
 # binary logging format - mixed recommended
 # binlog_format=mixed

重启mysql