2.6.1.3.2. Error 1153 Got a packet bigger than ’max_allowed_packet' bytes

The reason for the error is the presence in imported dump of a request, the size of which exceeds the parameter value set on the server max_allowed_packetequal to 16 MB. This situation can usually occur when the database is used to store files (for example, images) instead of the file system.

Insofaras configuration The MySQL server on the hosting is unavailable for modification, it is worth finding out exactly which queries the error occurs and trying to split them into parts. If the requests contain non-critical data (for example, the contents of the cache), you can try to remove it from the dump. As a last resort, you can consider the option of placing the database on VPS or dedicated server without our administration, where you can independently configure MySQL to fit your needs.

Content