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 > > --------------------------------------------------------------------- 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