1153 - Got a packet bigger than 'max_allowed_packet' bytes With statement

mysql导入超大文件报错，解决方案如下：

set global max_allowed_packet=10000000000; 


set global net_buffer_length=1000000;

FLUSH PRIVILEGES;

 

解释：

–max_allowed_packet=XXX 客户端/服务器之间通信的缓存区的最大大小;
–net_buffer_length=XXX TCP/IP和套接字通信缓冲区大小,创建长度达net_buffer_length的行数。