[peterlaursen]

1) the issue with 'empty database' is confirmed. It is related to 'autocomplete'. 'drop database' and 'truncate database' are not affected.

We will release 5.21 beta1 with a fix for this in a few days.

2) However we cannot reproduce the slow import.

Can you tell what 'Remote connection' means? HTTP??

If so that could depend on the server load then.

Can you reproduce with both versions installed at the same time?

(import with 5.19 … measure time .. drop database .. measure time)

[peterlaursen]

Please give us a little time to discuss what change in between 5.19 and 5.2 could do that.

As said there is no INTENTIONAL change.

But please detail this:

“I connect to my databases via ssh tunnel. Connect is successful.”

Can you connect to the SERVER but not the DATABASES, or is it 'test connection' that reports OK?

[peterlaursen]

Thanks for your research into this!

We will discuss this later today.

Just for clarity:

The report that multiple connections are not allowed, was a 'hoax' then?

However – actually we did an important change in the 5.1x tree. before that change we got data as POST datas now it is RAW data.

Could we have temporary access to your server so that we can test this in depth?

We don't need any data – just a few small dummy tables!

You can create a ticket to discuss further.

ADDED: actually we now reproduced exactly as you described by inserting “echo chr(10);” into the tunneller.

[peterlaursen]

Is this happening with all databases (in case you have more) or for one database only?

Also do I understand correctly that the databases are shown?

When clicking the plus sign in the Object Browser SQLyog sends these queries:

MySQL 3.23 and 4.0:

Code:

show tables from `dbname`;

MySQL 4.1 and higher:”

Code:

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

What happens if you write those queries yourself? You can even try MySQL command line client.

also try

Code:

create table newtable as select * from oldtable;

Is the newtable created correctly? If so you can DROP the table causing problems.

To my best belief it is a coincidence that this happens shortly after using the backup tool. This tool does nothing but sending SQL to the server.

[peterlaursen]

you can set the LIMIT in preferences.

just set it VERY HIGH (higher than the amount of rows you have).

[peterlaursen]

What are the INSERT statements like in your file? Single-row inserts for bulk inserts?

Basically you should use as large BULK inserts as your configuration allows for.

Was that the issue?

[peterlaursen]

oops …

I mistook your question with another. You are using SSH-tunnel of course.

Still please version 5.2.

Also you could restart the server and/or SSH if possible.

[peterlaursen]

Please first try version 5.2 and see if problem persists.

BTW: Are you using HTTP-tunnel?

[peterlaursen]

There is a refresh option in the 'edit' menu.

The corresponding icon is the 'recycle' icon.

To refresh the list of databases first select the most upper level (the connection) and refresh.

To refresh the list of tables in a database first select the the database and refresh.

[peterlaursen]

Could you please tell what EXACT message you get?

It is likely however that a firewall blocks direct connection to the MySQL server. You will then have to use HTTP-tunnelling or SSH-tunnelling (ENTERPRISE FEATURE only).

[peterlaursen]

There is no (intentional) change in any such functionality introduced with 5.2.

Please answer:

1) Your are perfectly sure that this problem occured the very same moment as you upgrade?

2) What was the version that you used before?

[peterlaursen]

Quote:

The queries are executed at different times, so I wouldn't want to execute them together.

You won't have to execute all the queries.

There are 2 options: 'execute' and 'execute all'. 'execute all' executes all queries on a tab, 'execute' only executes the one where the cursor is positioned.

As said we do plan to ame a RESULT tab 'sticky' or 'locked' but we have a few months work with other isssues before we can pay attention to that.

[peterlaursen]

Thank you …

But I must admit that I am not able to read your post!

In all of my browsers only some accented latin characters that do not make sense are displayed.

Could you possibly write in English?

.. or at least tell what language you are using?

[peterlaursen]

Any 'automatic updates' configured?

If you have 'Systems Restore' enabled you can try returning to a restore point a few days back.

[peterlaursen]

You need to write the two (or more) queries in the same query window like

Code:

show databases;
show variables;

or

Code:

show databases; show variables;

and presse 'execute all' (double green arrow or Shift+f5) and each. Now each query will open a tab.

We have plans to add a feature to 'lock'/'unlock' a result tab but it will take some months.

[Author]

Posts