mysql导入大小设置_增加mysql导入大小 (Increasing mysql import size)

This error has nothing to do with the php.ini, its clearly an error message from the DBMS.

You can increase the value of the max_allowed_packet in the my.cnf file:

[mysqld]

max_allowed_packet = 128M

After restarting your mysqld it should work (for larger data increase the value more)

If you try to "import with putty", i guess your are using mysql from command line, in this case you can start mysql with the --max_allowed_packet parameter e.g:

mysql --max_allowed_packet=128M -u root -p sampledb < dump.sql

Alternatively if you source the file from within a running mysql session you can set the parameter by:

set global max_allowed_packet=128M;

last example only is effective till next restart of mysqld, for a permanent solution stick to my first example.