Incorrect key file for table ONLY when using dotConnect

Incorrect key file for table ONLY when using dotConnect

Postby mpaul » Sat 08 Jan 2011 16:18

I'm a little confused here. I have a large table that I can successfully query from using a MySql client from (for example TOAD) but when I run the exact same query using dotConnect for MySQL I recieve the following error:

Incorrect key file for table 'C:\Users\MYSQLA~1\AppData\Local\Temp\#sqlbb8_255_0.MYI'; try to repair it.

I'm really confused here, any ideas?? I can read other smaller tables in the database, but this one is large (6 million). But like I said, it works fine using TOAD. here is a sample query.

select column1 from table where column1 = 'Y' order by column1 limit 0, 25
Posts: 2
Joined: Wed 08 Dec 2010 18:16

Postby Shalex » Mon 10 Jan 2011 18:16

This bug was discussed by the MySQL society at,362974,362974.

Please give us the following information so that we can reproduce the issue in our environment:
1) the DDL/DML script of your table. Contact us via this form;
2) the way you are working with it and your rough connection string (a small test project will be appreciated);
3) the versions of your MySQL Server and dotConnect for MySQL.
Devart Team
Posts: 7393
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for MySQL