[peterlaursen]

Does not the error message tell everything “Please use mysql_upgrade to fix this error.“? I think it does.

We had an identical report less than a week ago: http://forums.webyog.com/index.php?showtopic=7028

About the mysql_upgrade program read MySQL documentation: http://dev.mysql.com/doc/refman/5.5/en/mysql-upgrade.html

I think the server has been upgraded but after an upgrade that affects system tables you must run mysql_upgrade. If you do not have shell access to the server where this problem occurs you will have to point the sysadmins' attention to their mistake. You will not need to mention SQLyog at all becuase the error is not specific for SQLyog. Just tell that this valid statement

“SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'test' AND ROUTINE_TYPE = 'PROCEDURE';”

.. returns this error and the reason is that the latest upgrade requires mysql_upgrade to run an ALTER TABLE statement against the mysql.proc table.

[peterlaursen]

What package do you use for SSH on Windows? Cygwin? Or a commercial package of some kind? And what version of the software?

Also tell the Windows version. There are some unofficial Cygwin packages available on the Internet, that will work fine with Windows XP but not later Windows versions (they include a cygwin.dll that is very old). I struggled a lot with this myself years back. So you should take the offical Cygwin package (if you use Cygwin) from the offical website http://www.cygwin.com/

I think I used this guide http://www.howtogeek.com/howto/41560/how-to-get-ssh-command-line-access-to-windows-7-using-cygwin/ successfully a couple of years ago (on Vista),

[peterlaursen]

Ahh, that explains .. you have upgraded the server to your current version without executing 'mysql_upgrade'. You always should when upgrading.

[peterlaursen]

Not currently, and we have not studied it much yet.

We are discussing with another user requesting support for http://dev.mysql.com…on-plugin.html He claims

“Basically, this is [required]for using PAM

authentication on Windows clients”

Do you agree/disagree? Do you know more?

[peterlaursen]

“is a new issue with the latest versin of SQLyog. i.e. This was not a problem with an earlier version of SQLyog”.

We hear that often – also when it is not the case. But how can you tell? Do you have both versions installed? It is also very well possible that something happened with the server at about the same time as you upgraded. I can export successfully here with 11.01. And expand the node in the Object Browser as well.

Please tell: what happens if you execute the SQL statement:

“SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'test' AND ROUTINE_TYPE = 'PROCEDURE';”

(replace 'test' with your actual database name).

This is the query that is executed when you expand the node and if SQLyog returns an error on this statement, any client would do.

Information_schema is a memory database. Have you tried to restart MySQL? Also try these statements http://dev.mysql.com/doc/refman/5.5/en/table-maintenance-sql.html agaisnt the 'proc' table in the 'mysql' database (you may do from SQLyog 'tools' menu).

Also simply try the statement “SELECT * FROM mysql.proc”

[peterlaursen]

We have discussed. We will implement this after finishing releases in the 5.5x tree (that are all about stability and performance). Expected timeframe is 4-6 weeks.

[peterlaursen]

There is not and there will not be before 5.5.7 has been released as a GA. The developer team is struggling with some nastey issues. We hope to have this solved or at least identified in a couple of days, but it is quite unpredictable if it will take one day or one week..

The only thing I can promise now, is that we will discuss on next review meeting in team (planned for tomorrow) and update here.

[peterlaursen]

You can indent lines like in most editors: select the lines you wnat to indent and press the TAB key (and BACKTAB for 'unindent'). Note that 'preferences' (editor tab) has some settings on how this work. You may define the width of the indentation and you may define if a single TAB character should be inserted or a number of SPACE characters.

[peterlaursen]

We have this request

http://code.google.com/p/sqlyog/issues/detail?id=1521

But your question is fundamentally wrong. Any such functionalitly must be in the client and not in 'MySQL' (the server). the server does not display anything at all.

[peterlaursen]

Anyway .. we just saw your comment in the issuetracker!

[peterlaursen]

There is no such option. And the primary reason is how the various tabs in the interface are 'parents' and 'children' of each others. The QB tab cannot have a 'child' RESULT tab – only a QUERY tab can. If a RESULT tab (and MESSAGES and PROFILER tabs) should fit in the bottom of a QB tab the size of the canvas would reduce, and there is not too much space already.

But we have this in our issue-tracker: http://code.google.com/p/sqlyog/issues/detail?id=364 . We would let the program open a QUERY tab, paste the generated query there and execute it. That can be done. The question is: should we open a new query tab every time or just open such once and next time append a (new) query to same tab?

[peterlaursen]

Expected release date of SQLyog 11.1 is around 10 days from now.

[peterlaursen]

This is not normally required. All 9.x versions use the same key and when upgrading from one 9.x to another 9.x you are not prompted for registration detils (same for 10.x, 11.x etc.).

What did you upgrade from and to? Do you really experience this for every minor upgrade? If you do, please contact us at [email protected]. We will not discuss registration issues for registered customers in public.

[peterlaursen]

OK .. we have not discussed this in detail yet in our team as we have been busy with the 11.01 release.

We will discuss as soon as possible and update here.

[peterlaursen]

This has been discussed before. We cannot do it for legal/license reasons. The MySQL manual is – unlike the code – even not GPL licensed or 'dual-licensed'. Any redistribution of a single comma (!) from the manual requires a commercial license. Oracle themselves don't have this problem obviously.

[Author]

Posts