At 12:14 +1000 8/18/04, Jens Porup wrote:
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.
mysqldump has its own setting for max_allowed_packet. It sounds like
you'll need to increase the setting for mysqldump, not just the server:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]