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?.
Comments
0 comments
Please sign in to leave a comment.