When you dump table data from MySQL, you may end up pulling a large chunk of data and it may exceed the MySQL client's max_allowed_packet variable. If that happens, you might catch an error like this:
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `tablename` at row: 1627
The default max_allowed_packet size is 25M, and you can adjust it for good within your my.cnf by setting the variable in a section for mysqldump:
[mysqldump]
max_allowed_packet = 500M
hi .. u need to give the --max_allowed_packet in the mysqldump if u got these kind of errors
example:
mysqldump -u root -p --max_allowed_packet=512M -B dbname --tables tblnames > filename.mysql
Hi,
It must be –-max_allowed_packet (double hypen preceding, not single).
-Kenan
text2talk.ca
yes