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]

Reply via email to