Error 1153 Got a packet bigger than ‘max_allowed_packet’ bytes when importing into the database

Posted on by

After importing a .sql dump file using PhpMyAdmin into a MySQL database I got this error:

#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

Solved by changing “max_allowed_packet” to 10MB in the MySQL config file my.ini (on the target database only).

Was;

max_allowed_packet = 1M

Changed to:

max_allowed_packet = 10M