Devart Forums

Hello.

I am using dbForge Studio for MySql. Version 3.0.182. Professional Edition.

Everytime i try to run any large query I receive the error:
Los Connection to MySQL server during query.

I am running the same query with the MYSQL browser GUI and works fine.

LOAD DATA INFILE "C:/10182008.csv" IGNORE INTO TABLE teventos FIELDS TERMINATED BY ","

I am using WAMP with MYSQL v 5.0.51b running on top of Windows Professional XP SP3.

I read all the posts with the same error but I have a 24 hours time out configured for MySQL connections and it continue doing the same.

Is there a work around?

Thanks a lot.

A.

There are two timeout settings for connection: one for connect procedure and one for query execution. Please make sure that you have correctly configured the last one.

One question.

If I can do the query from the MySQL Browser GUI. Is dbForge Studio using other settings?

All the SELECT queries works fine. Only the INSERT ones are timing out.

what would be the parameter name to check?

MySQL Query Browser does not have timeout settings (maybe they are just set to infinite).

You can set execution timeout on the Advanced tab of the Database Connection Properties dialog box. You can find this dialog from popup menu of connection node in Database Explorer window.
Execution timeout is a client option, which allows to interrupt execution of query if server doesn't respond for a long time.

Thanks a lot. This seems to worked fine. Anyway the maximum time in second is 7200 (2 hours) that must be enough for most of the cases.

I set them both to 7200 (it seems to be the longest time), anyway sometimes it works some time does not.
I opted to go back to the MySQL Browser for this long queries

You can set timeout to 0 (infinite). MySQL Browser uses this value by default. After that your long query can be executed in dbForge too.

i have been having the same issues, i get that lost connection error, even though this works flawlessly with the query application that comes with mysql tools.
i even tried using a long timeout delay for both fields, and use zero too. but this doesnt work. my query uses 2 inner joins.

what can i do about it?

warp wrote:i have been having the same issues, i get that lost connection error, even though this works flawlessly with the query application that comes with mysql tools.
i even tried using a long timeout delay for both fields, and use zero too. but this doesnt work. my query uses 2 inner joins.

what can i do about it?

Could you please post the full version of the product?

i am using the query builder, the latest version from the site.
my sql 5.0.5b

bump!

any news regarding this issue ?

We couldn't reproduce the problem with Query Builder. But we have updated the product recently. You can upgrade it and try once more.
It is also possible that you are having problems with MySQL server itself, because you are using unstable version.

http://download.devart.com/dbforge/mysq ... rmysql.exe

it says 404, is it just me or the file is missing ?

We'll fix this as soon as possible.