"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 in the > previous failed efforts). This time it worked like a champ. So it's > an > issue with trying to disble foreing key? When I tried to alter the > table, after the load, to re-create the foreign key, there _were_ > constraint failures; so, who knows? I will say, however, that if it > was a foreign key constraint issue, the error message sure was > mis-leading.
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? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]