469,623 Members | 1,097 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 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 1159

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Kenneth Foli Jørgensen | 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
3 posts views Thread by jehugaleahsa | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.