I have a cron job that does a database backup for RT.
That backup is currently failing with the following error:
mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table
Attachments at row: 1784599
My mysqldump command looks like this:
/usr/local/mysql/bin/mysqldump --opt --skip-extended-insert
–skip-lock-tables --single-transaction --complete-insert
–max_allowed_packet=32M rt3 | bzip2 -9 > rt3.out-
I could increase the ‘max_allowed_packet’ setting.
I could add ‘–default-character-set=binary’.
Would these help?
Does anyone have any other suggestions?
Internode Systems Pty. Ltd.