[peterlaursen]

We will check.

[peterlaursen]

MONyog executes “SHOW GLOBAL STATUS” and retrieves the information from the server using this statement. Can you please try to execute the same? It may of course be a calculation/database error in MONyog but it can also be a server bug. What is the server version?

[peterlaursen]

Please reply to one question: can it happen that the .csv has a row (as identified by `code`) that does not exist in the database? If fhis is possible, what should then happen? Should such rows be INSERTED to the database or should they be ignored? 

[peterlaursen]

Why “choose a column” (in the Object Browser?) when  autocomplete will identify it for you when typing in the editor? 

[peterlaursen]

We have replied to this many times already.

 

SQLyog is a commercial program, and we only allow user to update for free after validation of his purchase history (and thus his legal rights to do so). This validation is implemeted in our Custoemer Portal.  I don’t see how it can be done in SQLog itself. 

[peterlaursen]

Is it really a big problem to type CTRL+T to open a new SQL editor? 

[peterlaursen]

Just mail to [email protected].

 

But please check from from the menu .. help .. about that you really are using version 12.07.  You may have multiple versions installed to different folders at the  same time and may be launching the program from a shortcut pointing to another (older) version

[peterlaursen]

We already have a similar requst in our issuetracker here: https://code.google.com/p/sqlyog/issues/detail?id=423.

 

There are no actual plans to implement tis. But there is one change since this was recorded: If you in the connection manager type a specific letter the list of connections will scroll down to the first connection name starting with that letter. So a workaround like this is possible: name your most important connections starting with “1_” and continue classifying the connections like that (“1_”, “2_” … “9_”)

[peterlaursen]

Please check with version 12.08 released an hour ago: http://blog.webyog.com/2015/02/09/sqlyog-mysql-gui-12-08-released/ “Escaped strings in a TRIGGER definition could have the escapes removed when copying and when using Schema Sync.  This fix is actually a workaround for a bug in MySQL.”

 

 

(and we actually execute both statements against the sorurce now)

[peterlaursen]

The dump does not have the statement “SET FOREIGN_KEY_CHECKS = 0;” on top. It should have if you are using Foreign Keys in the database. There is no way to ensure that ‘parent’ tables are written to the dump file before ‘child’ tables. 

 

Refer MySQL documentation http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_foreign_key_checks ” Disabling foreign key checking can be useful for reloading such tables in an order different from that required by their parent/child relationships”. 

 

SQLyog does write “SET FOREIGN_KEY_CHECKS = 0;” on top as default? Did you use SQLyog to create the dump? If so, did you uncheck this? 

[peterlaursen]

Please check with version 12.08 released an hour ago:

 

http://blog.webyog.com/2015/02/09/sqlyog-mysql-gui-12-08-released/

“When using HTTP-tunnel, SQLyog will identify itself to the webserver using a ‘user agent string’.  This string now identifies SQLyog as an  IE11-compatible application running on Windows 8.1. Before it was IE6 running on Windows XP. This has been reported to cause ‘denial of service’ with some hosting systems.”

[peterlaursen]

OK .. this is probably because the ‘user agent string’ in SQLyog emulates (or “fakes”, if you like) a browser version that the hosting systems will not allow to perform specific actions (not allow it to use PHP XML-extensions, for instance). We have not updated this ‘user agent string’ for many years now, and SQLyog probaby identies itself to the webserver as an IE version shipped with an early Win XP release.

 

Some links (if you are intereted in such technicalities):

http://stackoverflow.com/questions/5125438/why-do-chrome-and-ie-put-mozilla-5-0-in-the-user-agent-they-send-to-the-server

http://whatsmyuseragent.com/

https://msdn.microsoft.com/en-us/library/hh869301(v=vs.85).aspx

 

We should probably update this, so that we identify ourselves to the webserver as IE 11 running on a desktop/laptop (not smartphone/tablet) system. However, as it is long time since we were into this, we will need to study/refresh our minds and test before we can release.  But there are good chances that we can fix in beginning of next week. The last link above seems to tell what we should do about it. 

[peterlaursen]

MySQL 5.5.16 is a pretty old server.  Refer http://dev.mysql.com/doc/relnotes/mysql/5.5/en/. There may be a server bug involved. or a JAVA connector bug. Do you know the version of the JAVA connector?

 

Could you try with another client – such as ‘mysql’ commandline client?

[peterlaursen]

To determine the SQLyog version go to menu .. help .. about.

[peterlaursen]

It looks like we have no other option.  I don’t think MySQL will fix this as priority, and even after a fix has been made available, people will continue to use affected server versions for years.  

 

We are checking if it raises new problems to replace the statement.

[Author]

Posts