[MySQL]大量資料匯入時1153 錯誤：1153 - Got a packet bigger than 'max_allowed_packet' bytes

進入mysql
執行下面兩行 set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000; 參考來源
http://blog.csdn.net/shiershilian/article/details/23706131 大量数据导入时1153 错误：1153 - Got a packet bigger than 'max_allowed_packet' bytes