ERROR 1153 (08s01): Got a packet bigger than ' Max_allowed_packet ' bytes

Data import Error: Got a packet bigger than ' Max_allowed_packet ' bytes problem

Two workaround:

1. Temporary modification: Mysql>set global max_allowed_packet=524288000; Modify #512M

2. Modify MY.CNF, need to restart MySQL.

The configuration file is then adjusted:/etc/my.cnf

To modify the maximum allowable package size for MySQL
In the [Mysqld] section (not in this section useless) add a sentence:
max_allowed_packet=50m
Restarting the MySQL service is OK.

The restart command is as follows:

First, the way to start
1, use service to start: Service mysqld start
2. Start with mysqld script:/etc/inint.d/mysqld start
3. Use Safe_mysqld to start:safe_mysqld&
Second, stop
1, use service to start: Service mysqld stop
2. Start with mysqld script:/etc/inint.d/mysqld stop
3, mysqladmin shutdown
Third, restart
1, use service to start: Service mysqld restart
2. Start with mysqld script:/etc/inint.d/mysqld restart