List:MySQL on Win32« Previous MessageNext Message »
From:Mikhail Berman Date:September 14 2006 8:09pm
Subject:RE: MySQLDump
View as plain text  
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:melissa@stripped] 
Sent: Thursday, September 14, 2006 3:48 PM
To: dpgirago@stripped
Cc: win32@stripped
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: <dpgirago@stripped>
To: "Melissa Dougherty" <melissa@stripped>
Cc: <win32@stripped>
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=1

Thread
Fw: MySQLDumpJorge Bastos13 Sep
  • Re: MySQLDumpMelissa Dougherty13 Sep
RE: MySQLDumpPaulo Urcid Pliego13 Sep
  • Re: MySQLDumpMelissa Dougherty14 Sep
Re: MySQLDumpdpgirago14 Sep
  • Re: MySQLDumpMelissa Dougherty14 Sep
Re: MySQLDumpdpgirago14 Sep
RE: MySQLDumpMikhail Berman14 Sep
  • Re: MySQLDumpMelissa Dougherty15 Sep
Re: MySQLDumpMelissa Dougherty19 Sep