CentOS MySQL massive data import 1153 error: 1153-got a packet bigger than ' Max_allowed_packet ' bytes

Reference: Http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes

Write test data with a script, OK on Ubuntu, did not expect the CentOS 1153 error. Workaround:

Log in to MySQL and execute:

Set global net_buffer_length=1000000; Set global max_allowed_packet=1000000000;

It's OK.

If it is a SQL script, you can import it with the following command

MySQL--max_allowed_packet=100m-u root-p Database < insert for large amounts of data. sql

CentOS MySQL massive data import 1153 error: 1153-got a packet bigger than ' Max_allowed_packet ' bytes