469,269 Members | 1,006 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,269 developers. It's quick & easy.

MyODBC connection dies during data transfer

jj
I've got a table of about 400,000 records but when I transfer it from Access
to MySQL, the ODBC connection dies around 3,000 records or so (or about
3-5mins) with this error:

ODBC -- call failed

[MySQL][ODBC 3.51 Driver][mysqld-3.23.41] Lost connection to MySQL server
during query (#2013)

Once this error occurs, the table and uploaded records are removed from
MySQL.
But I've transferred other tables with a few thousand records just fine.
One query even runs for about 10 minutes or more with no problem.

Any ideas?


Jul 19 '05 #1
0 1468

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Kenneth Foli Jrgensen | last post: by
1 post views Thread by Jim Mitchell | last post: by
16 posts views Thread by crbd98 | last post: by
reply views Thread by jeff.dyke | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.