Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table
- by Imagineer
I'm getting the above mentioned error when backing up with ZRM, which is using mysqldump for backup.
mysqldump --opt --extended-insert --single-transaction --create-options --default-character-set=utf8 --user="
" -p --all-databases "/nfs/backup/mysql01/dailyrun/20091216043001/backup.sql"
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table TICKET_ATTACHMENT at row: 2286
I have increased the size for 'max_allowed_packet' to be 1G in /etc/my.cnf which is the server setting and for the client side setting I've set it by running this command:
mysql -u -p --max_allowed_packet=1G
And I have verified that on the client and server side they are of the same value.
This is to check the client side value according to this forum posting http://forums.mysql.com/read.php?35,75794,261640
mysql SELECT @@MAX_ALLOWED_PACKET
- ;
+----------------------+
| @@MAX_ALLOWED_PACKET |
+----------------------+
| 1073741824 |
+----------------------+
1 row in set (0.00 sec)
And this is the check the server value setting.
mysql SHOW VARIABLES
| max_allowed_packet |
1073741824 |
I have ran out of ideas, and tried searching within expert exchange and googling for solutions but so far none has worked.
Reference
http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html
Anyone please advise, thank you.
