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 connection or server gone away error message. When I altered the table to drop the foreign key constraint, the LOAD when just fine. I'd be happy to send the SQL files that create the tables and load the data. Have to figure out what to do about some data. Do you mean send the SQL files and a small set of data to the list or directly to Egor? Thanks for the help. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]