Re: LOAD Fails on Lost Connection

2003-09-17 Thread Randy Chrismon
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

Re: LOAD Fails on Lost Connection

2003-09-17 Thread Egor Egorov
"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

Re: LOAD Fails on Lost Connection

2003-09-16 Thread Randy Chrismon
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

Re: LOAD Fails on Lost Connection

2003-09-15 Thread Matt W
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

LOAD Fails on Lost Connection

2003-09-15 Thread Randy Chrismon
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