Randy Chrismon [EMAIL PROTECTED] wrote:
I read the MysQL documentation re the Server Gone Away error but
nothing there applied to my situation. On a whim, I re-created the
table I was trying to import into but without the foreign key
constraint (I had only disabled the foreign key constraint
Egor Egorof said:
If I've got you right, you get Lost connection error when foreign
key constraints is turn on?
Could you provide your table structure and some data for testing?
Well, I designed the table with a foreign key constraint, then I
disabled keys, tried to LOAD and got the lost
I read the MysQL documentation re the Server Gone Away error but
nothing there applied to my situation. On a whim, I re-created the
table I was trying to import into but without the foreign key
constraint (I had only disabled the foreign key constraint in the
previous failed efforts). This time it
I've tried this several times:
mysql source c:/mysql/import_cash.sql
with this error:
ERROR 2013: Lost connection to MySQL server during query
from the commandline, using:
C:\mysql -u myname -pmy_password my_database
c:/mysql/import_cash.sql
I get the same error. This happens immediately, so
Hi Randy,
See here: http://www.mysql.com/doc/en/Gone_away.html
Maybe one of the queries in import_cash.sql is longer than
max_allowed_packet?
- Original Message -
From: Randy Chrismon
Sent: Monday, September 15, 2003 4:50 PM
Subject: LOAD Fails on Lost Connection
I've tried