Mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table

Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table

When a MySQL client or the mySQL server gets a packet that is larger than the max_allowed_packet bytes, it throws error and closes the connection. We can increase the value temporarily for taking mysqldump.

#mysqldump --max_allowed_packet=512M database > database.sql

Here we need to replace the required database name. Please note that this configuration is temporary.

That's all…

Leave a Reply

Your email address will not be published. Required fields are marked *