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