错误类型：
ERROR 1231 (42000): Variable 'time_zone' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'foreign_key_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'unique_checks' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'character_set_client' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'collation_connection' can't be set to the value of 'NULL'
ERROR 1231 (42000): Variable 'sql_notes' can't be set to the value of 'NULL'
解决方式：也可能为数据库函数功能未开启
方式一：
mysql> set max_allowed_packet=1024M; --只对当前会话生效
mysql> source ./xxxx.sql;
方式二： 永久生效修改my.cnf
[root@localhost ~]# vim /etc/my.cnf [mysqld] max_allowed_packet = 500M [mysqldump] quick max_allowed_packet = 500M
参考文章：http://www.bubuko.com/infodetail-646948.html
以上就是MySQL数据导入sql文件过程中出错的详细内容，更多关于MySQL数据导入sql文件过程中出错的资料请关注九品源码其它相关文章！