Dear Carlos, > 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.
Which version do you have? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Carlos A." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 7:25 PM Subject: Re: mysqldump error > 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 > --------------------------------------------------------------------- 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
