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 con
"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 const
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
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
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