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]



Reply via email to