NavicatforMySQL导表时报错Gotapacketbiggerthan‘max_allowed_packet‘bytes

或者还原数据只时&＃xff0c;有个别表报 MySQL server has gone away 也可以试试加大max_allowed_packet。

按F6打开命令行窗口&＃xff1a;

-- 查看
mysql>show VARIABLES like &＃39;%max_allowed_packet%&＃39;;
-- 设置后退出再进来查看&＃xff08;别人这么说&＃xff0c;我就这么做了&＃xff09;
mysql>set global max_allowed_packet &＃61; 210241024*10;


反正我这么设置后是OK了。

Navicat报Got a packet bigger than ‘max_allowed_packet’ bytes错误
Got a packet bigger than‘max_allowed_p错误?