Re: mysqldump error

[Carlos A.]

thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again:
mysql --debug -e"select * from table" > /tmp/lista.log
ERROR 2013 at line 1: Lost connection to MySQL server during query
I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql.

From: "Listen Hinz" <[EMAIL PROTECTED]>
To: "Carlos A." <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: Re: mysqldump error
Date: Thu, 5 Dec 2002 18:16:40 +0100

Dear Carlos,

> Got error: 2013: Lost connection to MySQL server
> during query
> when retrieving data from server

In your my.cnf / my.ini configuration file, set the value for the
communication buffer high (maximum is 16 MB):

[mysqldump]
set-variable = max_allowed_packet=16M

Restart the server, and the dump should work.

HTH!
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3


----- Original Message -----
From: "Carlos A." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 3:13 PM
Subject: mysqldump error


> Hello
> I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I
get an
> error when run mysqldump in order to backup my dbs. The error is
following:
> /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL
server
> during query
> when retrieving data from server
> I ran mysqldump with --opt or without it, the error is the same.
> I must say the table have many registers, almost 200.000
> PD: I ran myisamchk before do the dump, and the error remains.
>
> Thanks in advance.
>
>
>
>
>
>
>
> _________________________________________________________________
> MSN Fotos: la forma más fácil de compartir e imprimir fotos.
> http://photos.msn.es/support/worldwide.aspx
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

_________________________________________________________________
MSN. Más Útil Cada Día http://www.msn.es/intmap/


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php