Hi.
Thanks for your help.
The problem has been solved by adding the default character set directive.
Kind regards.
Luke.
Luke Vanderfluit wrote:
Hi.
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-`date
+\%Y\%m\%d-\%H`.bz2
I could increase the 'max_allowed_packet' setting.
I could add '--default-character-set=binary'.
Would these help?
Does anyone have any other suggestions?
Kind regards.
--
Luke Vanderfluit.
Analyst/Programmer.
Internode Systems Pty. Ltd.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
We're hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html
