Friday, August 19, 2011

I got this  weird message today doing a mysqldump.

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

Answer is to add --max_allowed_packet= to your command line.

E.g. time mysqldump --max_allowed_packet=512M database > database.sql.

HTH

Brent

No comments:

Post a Comment