[peterlaursen]

You will ahve to explain WHAT doe snot work correctly.

However please try 5.22 RC1!

[peterlaursen]

Now, actually we fixed an issue with ALTER TABLE .. advanced properties in RC1.  Please try this one.

I cannot reproduce your issue with neither beta2 nor RC1 (and I am not sure I understand either).

If there is any such issue with RC1 please post a screenshot!

[peterlaursen]

SQLyog 5.22 RC1 is now released.

 

[peterlaursen]

We have had this issue a couple of times before.  It occurs because of a privilege issue (privileges to the `Information_Schema` table) on the server.  Basically ist is because of a mistake by Sysadmins when upgrading MySQL.

SQLyog sends the query:

Code:

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = '***' and `TABLE_TYPE` = 'BASE TABLE'

What happens if you write that query yourself? You SHOULD be able to get result from the objects that are yours!!

However also read this:

http://www.webyog.com/forums//index.php?sh…view=getnewpost

.. from next release we we not query information schema when there are other ways to get the information.

[peterlaursen]

However ..

we are not impressed with this 'solution' my MySQL AB.    🙁

Queries to Information_Schema is still slow compared to “SHOW …” and “SHOW … STATUS … ” statements.  From version 5.22 RC1 we will try to avoid querying Information_Schema whenever possible.  We think that it is possible everywhere except when clicking the + sign left to the 'triggers' folder in Object Browser (there is a privilege issue here as it takes the SUPER privilege to “SHOW TRIGGER STATUS ..”).

[peterlaursen]

This is a known issue with the MySQL Server and not SQLyog.

(queries to `Information_schema` are slow – try searching [url=”http://bugs.mysql.com!!))”]http://bugs.mysql.com!!))[/url]

MySQL claims that this is fixed (at least the bug reports are closed).  

You should upgrade the server version to 5.0.27/28 or 5.1.14.

(Also you should upgrade SQLyog .. but for other reasons!)

[peterlaursen]

I must admit that I personally know very little about this.

I have 'called in' assistance to explain in detail.

Please be a litttle patient.

[peterlaursen]

There is an easier way.  There is a 'refresh icon.  It looks like a 'recycle' symbol.  Click this one and everything in the lower level will refreshy. (to refresh the list of databases, highlight the connection and press 'refresh'; to refresh the list of tables in a database, highlight the database and press 'refresh' etc).

'refresh' is also available from the 'edit' menu and the keyboard shortcut.

[peterlaursen]

It is a bug and a known one.  The issue is that the Win32 API uses “&..” sequences to identify menu items and the keyboard shortcuts used for activating them (an example: often you can activate the 'file' menu by pressing “ALT-f”. In the code the string “file” is written like “&file” what sets the keyboard shortcut ALT-f active for that menu).  Basically we need to turn that off somehow in certain contexts.  It is not very simple and that is why it is not fixed yet.

This only affects the display – not the data themselves.

The issue is documented here: http://code.google.com/p/sqlyog/issues/list . Refer to issue #3.

[peterlaursen]

No there is nothing to 'enable' if I understand your question right.  No configuration on the host/network where the MySQL is, is required.

Technically (from a programmer's perspective) it is almost the same wheter you connect to a HTP server on a remote host/network (and connct to a MySQL server from here) or whether you connect to a Proxy server on your local network and connect to a MySQL server from here.  That is why we have arranged this where it is.

The easiest would be to try!  

[peterlaursen]

Yes .. the ENTERPRISE version supports proxies.

(setting are on Tunnel tab .. HTTP-tunnelling .. advanced button)

Download the TRIAL today and try for yourself.

Please report any problem (but there should not be).

[peterlaursen]

We just tried every option (including join-type) that we can figure out with both program versions.

We cannot reproduce any such issue.

We will need more info – best of all a 'reproducable test case'

[peterlaursen]

No explanation at this moment!

But as it works correctly with 5.19 and not 5.21 it looks like we have an issue.

We will research into that now.

Can you procide a 'test case': a complete export with 5.19 and 5.21 respectively and attach.  You can create a ticket and attach to the ticket if you don't want to expose the data in public.

Also: does this only and always happen inside 'inner join' constructs?

[peterlaursen]

We do not yet provide such option from the GUI.

You can use SQL like 

“CREATE DATABASE DEFAULT CHARSET cp850”

“CREATE/ALTER TABLE tablename DEFAULT CHARSET cp850”

(and the charset for the databae and/or table will be different from the server default.

You can change the server defa

But two things you should note:

1)  This will only have effect on NEW databases and tables.

2)  After that when connecting with SQLyog choose 'cp850' for the connection and not '

default'  

[peterlaursen]

I am afraid that I do not understand you.  But I think I understand that you have 2 issues.

1st issue:  some 'locking'/performance issue.  

This I do not understand at all.  Please detail and post an example/a 'test case'.

2nd issue: the URL cannot be found.

* Is the URL correct?  Not literally mydomain.com what what it is?

* Can you access the tunneller from a browser using the same URL?

[Author]

Posts