Devart Forums

Posted: **Tue 20 Sep 2011 14:37**

I have a table with a lot of data. If I want to change a default setting or add an index, DBForge Studio for MySQL 3.5 is not responding. After a while the connection is lost.

My example:

Code: Select all

ALTER TABLE nelis.bolnamen
  ADD UNIQUE INDEX btree_expnaamid (exporteur, naamid);
Error: Lost connection to MySQL server during query

Is there a setting that the query will be executed without losing a connection. In the tabform Database connection Properties -> Advanced the Execute Timeout is set to 0

Posted: **Tue 20 Sep 2011 14:43**

If I reopen the conncetion I can see the created index. But I Don't know if the index is fully created.

Posted: **Wed 21 Sep 2011 07:11**

You are using an old version of the tool. As far as I know, we did some fixes connected with lost connection while creating an index. So, please upgrade to the v5.0 of the tool and check whether the problem persists.

Devart Forums

lost connection during execute

lost connection during execute