Tag Archives: mysqldump

ERROR 1153 at line 4528: Got a packet bigger than “max_allowed_packet” bytes mysqldump

mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’

Error: Getting the following error while taking the backup of database with mysqldump utility

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `mailbox_app` at row: 4528

Cause: default max_allowed_packet value is 64MB.

Solution: We can increase the value of this parameter in mysqldump command as shown below: You can increase value according to your need 512M or 1024M.

mysqldump --max_allowed_packet=1024M  --routines=true -u [user] [database] > Dbbackup.sql

Note: this will fix my error