G'day, Trying to get a dump of a production database in mysql 3.23.54, mysqldump version 8.22.
This is what I'm getting: rack002:~# mysqldump -u root -p rt2 > rt2.dump Enter password: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' when dumping table 'Attachments' at row: 36763 I have tried to increase the max_allowed_packet in /etc/mysql/my.cnf, thusly: set-variable = max_allowed_packet=64M and then restarted the server, but no joy. Google is not my friend. Nor the list archives. Help? Jens fyi: rack002:~# mysqldump --version mysqldump Ver 8.22 Distrib 3.23.54, for pc-linux-gnu (i686) This is on a Debian server running Stable. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]