Case Study: MySQL Database error – Max_Allowed_Packets

Hi,

Problem Summary: One of our customer is getting this error message while restoring his domain’s database backup which he has taken from old hosting provider:

WordPress database error: [Got a packet bigger than 'max_allowed_packet' bytes]

Possible solutions:

1) It is possible that /tmp folder is full…so need to restart the service for MySQL server which may resolve the issue.

2) It is possible that MySQL database dump is corrupted or MySQL database is corrupted. Hence, check the dump and repair the database after that have a check with restoration process.

3) It may be possible that client is trying to upload the database dump file more that allowed limit. Hence, he need to contact service provider to increase the limit for max_allowed_packet for MySQL. By default, in cPanel server is 1MB but it can be override from /etc/my.cnf file.

In this case our client was trying upload the file more than 20MB. Hence, we have set the limit for Max_Allowed_Packet to 24MB and restarted MySQL service which has fixed the problem.

Thanks,

Shane G.

Popularity: 5%