try "mysqldump -q" ruza
On 07/06/06 01:07, 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. > -- Pavel Ruzicka, ICZ *** ICZ a.s. ****************************** Hvezdova 1689/2a, 140 00 Prague 4, CZ tel: +420 24 41 00 111 _ Fax: +420 24 41 00 222 @_}-,^--`-- GSM: +420 724 429 641 mailto:[EMAIL PROTECTED] http://www.i.cz ******************************************* _______________________________________________ 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
