20 messages in com.mysql.lists.win32Re: MySQLDump
FromSent OnAttachments
Melissa Dougherty07 Sep 2006 09:37 
Melissa Dougherty07 Sep 2006 09:51 
Michael Louie Loria12 Sep 2006 18:54 
Mikhail Berman13 Sep 2006 06:41 
Melissa Dougherty13 Sep 2006 07:54 
Mikhail Berman13 Sep 2006 08:04 
Jorge Bastos13 Sep 2006 08:41 
Jorge Bastos13 Sep 2006 10:19 
Melissa Dougherty13 Sep 2006 10:20 
Melissa Dougherty13 Sep 2006 11:46 
Jorge Bastos13 Sep 2006 14:21 
Urcid Pliego, Paulo13 Sep 2006 14:40 
Michael Louie Loria13 Sep 2006 17:45 
Melissa Dougherty14 Sep 2006 11:35 
dpgi...@mdanderson.org14 Sep 2006 11:56 
Melissa Dougherty14 Sep 2006 12:47 
dpgi...@mdanderson.org14 Sep 2006 13:01 
Mikhail Berman14 Sep 2006 13:08 
Melissa Dougherty14 Sep 2006 18:29 
Melissa Dougherty19 Sep 2006 06:58 
Subject:Re: MySQLDump
From:Melissa Dougherty (meli@cse-corp.com)
Date:09/14/2006 06:29:23 PM
List:com.mysql.lists.win32

I put it in both....

----- Original Message ----- From: "Mikhail Berman" <mber@ivesinc.com> To: "Melissa Dougherty" <meli@cse-corp.com>; <dpgi@mdanderson.org> Cc: <win@lists.mysql.com> Sent: Thursday, September 14, 2006 4:09 PM Subject: RE: MySQLDump

In my.cnf there are two sections where max_allowed_packet value can be set.

One in [mysql] and one in [mysqldump]

Please check where you setting your value, you need [mysqldump] section.

Hoping this helps

Mikhail Berman

-----Original Message----- From: Melissa Dougherty [mailto:meli@cse-corp.com] Sent: Thursday, September 14, 2006 3:48 PM To: dpgi@mdanderson.org Cc: win@lists.mysql.com Subject: Re: MySQLDump

I increased the limit to 1gb... but got the same error. Do you think if I turned on the general query log it would give anymore info?

Melissa

----- Original Message ----- From: <dpgi@mdanderson.org> To: "Melissa Dougherty" <meli@cse-corp.com> Cc: <win@lists.mysql.com> Sent: Thursday, September 14, 2006 2:57 PM Subject: Re: MySQLDump

I increased the max_allowed_packet variable to 72m from 64m and also upped the connect_timeout. But the dump still error the same way.

Melissa

The manual says:

The protocol limits for max_allowed_packet is 16M in MySQL 3.23 and 1G in MySQL 4.0.

Perhaps I've not been following this thread closely enough, but why not make it a gigabyte, just as a test??

-- David

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=mber@ivesinc.com

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=meli@cse-corp.com