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]