[peterlaursen]

We will discuss this. Personally, I think this request makes sense. Basically for the reason that the COPY may take considerable amounts of time with large tables and then the user need to take a coffee-break for as long!

I remember that the CREATE/ALTER TABLE was a modal dialog in old versions (more than ~8 years old, as far as I remember). To avoid the modality we implemented it in a TAB instead. This may be a solution here as well. I will ask developers to check if this is feasible.

[peterlaursen]

NO, we have not.  We use Scintilla.

[peterlaursen]

After thinking a little it could also be a problem with “session restore” database being written to you “roaming” fodler on the central server.  . You may try to turn that feature off temporarily too – just in order to identify the culprit here.  It must be either “autocomplete” or “session restore” I think. 

[peterlaursen]

[attachment=2065:tags.PNG]

 

Image showing this option.

[peterlaursen]

I don’t understand how you “temporarily set Appdata to my c: drive”..

 

But there is an option in menu .. tools .. preferences .. Power Tools tab to specify a folder where local databases used by “autocomplete” is stored.  Here you may specify a local folder. Please try this. It is undoubtedly the traffic (reads and writes) that autocomplete needs that causes this irresponsivenes.  Please try this. The option was added many years ago exactly for use on networks there users’ ‘roaming profiles’ are stored on a cental server. 

 

You can also first try to disable autocompelte temporarly and check if that helps.

 

 

[attachment=2064:tags.PNG]

[peterlaursen]

I have replied in the ticket you created.

 

We will check. But it is not reproducible for me (also not with SSH tunnel). I doubt there is any change in 12.19. 

How many rows does the table have? Do you use a LIMIT (globally for this table) or not? … Is it the same with all tables? Are you not even able to use the ‘abort’ button (the red cross marked in one of the images). SQLyog will wait for the server to return the result from the query that was sent to the server. As long as this has not hapenedyou cannot do anything but wait (or killl the thread)

It also may be your connection quality that has detoriated or the server has just become terrible slow. You may check wiht any client (command line orwhatever running from same machine as SQLyog. Simply copy the statement from SQLyog HISTORY tab and execute the statement in this other client. It happens almost everytimne we release a new version that some user will run into a problem after upgrading and assume that the problem is with SQLyog. But it may be a coincidence that it happens almost simultaneously. First step in such case should always be to check that the server/hosting is working properly.

 

 

Please conntinue either here or there. It is easiest to have eall information in one place. 

[peterlaursen]

Just information: Vika’s problem was solved in a private ticket he also created.

[peterlaursen]

I cannot really think of an automated soluiton.  If I understand the problem is that the target (MySQL) tables use Foreign key Constraints, but the source (Excel) has no idea of such things. 

[peterlaursen]

It could be due to some small and insignificant formatting difference (a whitespace or whatever) introduced during transfer to the client. My best guess right now. 

 

What is/are the server version(s) involved?

[peterlaursen]

I think that the reply already given – ie. The option “To be dropped|created|altered in target”  is applicable only to tables,views,stored procedures,function,trigger and events (“1st level” database objects) ..” explains. Am I missing something? 

[peterlaursen]

Pleae tell your SQLyog version. And please refer 12.15 release notes http://blog.webyog.com/2015/10/07/sqlyog-mysql-gui-12-15-released/ “SQLyog updated connrestore.db file even when there were no changes in the current session. This is now fixed.”

[peterlaursen]

The option “To be dropped|created|altered in target”  is applicable only to tables,views,stored procedures,function,trigger and events (“1st level” database objects) present in the target but not in the source. The options under “hide and ignore objects” are applicable only to these objects but not ‘subobjects’ – ie. table columns and indexes. If you choose to “hide and ignore” ‘objects to be altered’ you will see that no script is generated. 

 

The purpose of the tool is  ‘synchronization’ of “1st level” objects as listed and it works as expected. 

[peterlaursen]

More questions:

 

Can you also please try same UPDATE statement with another client (you may copy it from HISTORY tab in SQLyog). What happens?

Also does the UPDATE succeed or not?

Is the table ‘parent’ in a Foreign Key setup?

Does it help to “OPTIMIZE TABLE `hatch_summary`;”? 

 

We need not only the table structure, but a full testcase (struture, data and statement/instruction (screenshot is a good thing here) on how you use GUI) where it is reproducible.

 

But as asked by Sibin, please elaborate the exact meaning of the term “crash” as you experience it here. If there is a crash-dump, please attach it.

[peterlaursen]

As replied many times before, there is very little chance that configurable keyboard shortcuts will be implemented. 

[peterlaursen]

This could be a server issue (ie. server returning the user@host -strng unquoted).

 

What is the server version? Can you provide a simple example where it happes and one where it does not? 

[Author]

Posts