Lost Connection Upon Loading Dump
- Date: Thu, 21 Apr 2016 11:51:21 -0400
- From: Stephen R Guglielmo <srguglielmo@xxxxxxxxx>
- Subject: 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
# 16 MB
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
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