MySQL Import data failed: MySQL Max_allowed_packet set too small

MySQL restricts the size of packets accepted by the server according to the configuration file.

Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, causing the write or update to fail.

View current configuration

Show VARIABLES like '%max_allowed_packet% ';

The current configuration is: 1M

Modify method

1. Modify the configuration file

You can edit the my.cnf to modify (under Windows My.ini) and modify it in the [Mysqld] section or in the MySQL server configuration section.

Max_allowed_packet = 20M

If you can't find the MY.CNF, you can pass

MySQL--help | grep my.cnf

To find the my.cnf file.

Under Linux the file is under/etc/.

2. Modify in MySQL command line

Run in the MySQL command line

Set Global Max_allowed_packet = 2*1024*1024*10

Then exit the command line, restart the MySQL service, and then enter.

Show VARIABLES like '%max_allowed_packet% ';

See if the next Max_allowed_packet is edited successfully

Note: This value is set too high to cause a single record to exceed the limit after the write to the database fails, and subsequent record writes will fail.

MySQL Import data failed: MySQL Max_allowed_packet set too small