June 15

mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table

mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table:

need to add --max_allowed_packet option to command:
mysqldump --max_allowed_packet=512M some_db >> /root/some_db.sql


Copyright 2021. All rights reserved.

Posted 15 June 2016 by admin in category "simple memo

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.