Unable to restore backup: Got a packet bigger than 'max_allowed_packet' bytes

Created:

2017-03-21 16:17:45 UTC

Modified:

2017-08-08 13:45:48 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to restore backup: Got a packet bigger than 'max_allowed_packet' bytes

Issue Symptoms

Unable to restore backup following error occurs:

Warning:
Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases/dataabse_name[sqldump]: backup_1703110201.tgz
Warning:
Execution of /usr/bin/mysql --no-defaults -u dbuser -h localhost -P 3306 --default-character-set utf8mb4 dbname failed with return code 1. Stdin is source /tmp/migration-unpack-VMpKld/backup_1703110201; exit Stderr is ERROR 1153 (08S01) at line 385 in file: '/tmp/migration-unpack-VMpKld/backup_1703110201': Got a packet bigger than 'max_allowed_packet' bytes

Conditions

Value of max_allowed_packet is small in  /etc/my.cnf.

Resolution

Increase max_allowed_packet according to How to set max_allowed_packet size for MySQL?.

Have more questions? Submit a request
Please sign in to leave a comment.