Web lists-archives.com

Re: Lost Connection Upon Loading Dump




On 4/21/2016 10:51, Stephen R Guglielmo wrote:
Hello,

I have a empty db that I'm trying to load a .sql file (created via
mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the
dump is consistently failing at line 1763. Line 1763 is an INSERT
statement. The line is 95610 characters long.

The error is:
ERROR 2013 (HY000) at line 1763: Lost connection to MySQL server during query

About 40 tables are restored correctly from the dump prior to it
failing at this line.

Based on advice from posts I've found on the internet, I've added the
follow settings to my.cnf
net_read_timeout=60
# 16 MB
max_allowed_packet=16777216

I added these to both the [mysqld] and [mysqld_safe] sections to be
sure. I restarted mysqld, but still get the same error upon loading
the dump.

I'm not seeing anything in my error log (do I need to enable more
verbose error logging?).

MySQL Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using readline 5.1

I would appreciate any advice on figuring this out.

Slow: change the mysqldump params to turn off multiple inserts per
statement, and run the dump again.

Faster: grow the mysqldump net_buffer_length setting, and the mysqld setting of the same name, to accommodate the largest multiple insert. You may also have to grow max_allowed_packet.

PB

-----



Thanks,
Steve



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