Gossamer Forum
Home : Products : Others : MySQLMan :

Import problem - Lost Connection

Quote Reply
Import problem - Lost Connection
I get this error from time to time when editing a table, yet the edits apply:

MySQL said: Lost connection to MySQL server during query

However I always get this when importing (local) and this is always unsuccessful.
Any suggestions welcome -
Thanks,
CG
Quote Reply
Re: [AutoExcrement] Import problem - Lost Connection In reply to
How large is the data file that you are attempting to import??? Sounds like it is quite large and your MySQL server is "timing out" and thus the connection is lost.

If the file is larger than 1.0 MG, I would suggest breaking up the file into multiple files, then upload the files separately.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [AutoExcrement] Import problem - Lost Connection In reply to
By default queries timeout after 8 hours so I'm assuming it could be something else. (Unless your host altered wait_timeout)

Have you tried importing from the shell?
Quote Reply
Re: [AutoExcrement] Import problem - Lost Connection In reply to
No, don't think its a time issue or a file size issue. I can create a text file with only 5 pipe delimited words and try to import to a 5 column table and still get the Lost Connection...
Maybe there is something simple I'm missing.
Thanks for the help, any other thoughts?
CG
Quote Reply
Re: [AutoExcrement] Import problem - Lost Connection In reply to
Have you tried importing from telnet or ssh?
Quote Reply
Re: [AutoExcrement] Import problem - Lost Connection In reply to
No. I don't have telnet access as of now. I will eventually contact our sys admin to attain that if I have to. Thought I would expend my possibilities with the Manager first...
Might be a good next step though.
Thanks,
CG