Symptoms

The following error is thrown when trying to import a database dump in PHPMyAdmin:

Got a packet bigger than 'max_allowed_packet' bytes

Cause

Communication packet size is greater than the limit configured for MySQL.

For more information about this error, please refer to the MySQL documentation.

Resolution

Increase the packet limit in MySQL configuration file /etc/my.cnf , e.g. by adding line 'max_allowed_packet = 32M' (limit may vary) and restart mysqld service.

Internal content