Hello.


Does your problem still exist? Are you able to perform the dump

by hand with mysqldump? Is it possible that your table has grown

so the default value of max_allowed_packet is too small. What version

of MySQL do you have. See:

  http://dev.mysql.com/doc/mysql/en/communication-errors.html

        http://dev.mysql.com/doc/mysql/en/gone-away.html

        http://dev.mysql.com/doc/mysql/en/packet-too-large.html





Tom Cunningham <[EMAIL PROTECTED]> wrote:

> Hi list,

> 

> our overnight backup scripts have suddenly been getting a lot of

> mysqldump errors like:

> 

> mysqldump: Error 2013: Lost connection to MySQL server during query

> when dumping table `cs_email_things` at row: 512234

> 

> I've checked the obvious things, and no luck:

> * disk space is OK

> * nothing in the mysqld log

> * nothing in /var/log/messages/

> * CHECK TABLES doesn't complain about the tables

> 

> In fact, now that I think of it, it's happened on two different

> servers; though mysqldump is always running on the same machine.

> 

> Any ideas?

> 

> Thanks.

> 

> Tom.

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to