mysql 3.23.49a
From: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]>
Reply-To: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]>
To: "Carlos A." <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: Re: mysqldump error
Date: Thu, 5 Dec 2002 22:02:49 +0100
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
_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es
---------------------------------------------------------------------
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
