[rt-users] mysqldump refusing to finish

[Pavel Ruzicka]

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:pavel.ruzicka at i.cz http://www.i.cz
*******************************************