Stephen R Guglielmo Lost Connection Upon Loading Dump
Apr 21, 2016; 11:51
Stephen R Guglielmo
Lost Connection Upon Loading Dump
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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Peter Brawley Re: Lost Connection Upon Loading Dump
Apr 21, 2016; 18:12
Re: Lost Connection Upon Loading Dump
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!