[peterlaursen]

In your ticket I replied

1) that I can connect to your server every time without problems with any SQLyog version with the connection details that you gave us.

2) and asked you to try connecting from another location and to enable logging in the tunneller.

[peterlaursen]

” When i try to copy a table to a different host i get the following error …”

does that only happen when 'copy to other ..” and else not?

“If i use a previous version of sqlyog it works fine.”

Please tell exact what version works!

Let me guess that you are tunnelling  to one or both servers?

If so you connect to MySQL from 'localhost' (form the webserver or SSH-daemon)

Another possibily is that you use SSH-tunnel and SSH-host is different from MySQL host.

If SSH-forwarding fails then it might try to connect to 'localhost' (the SSH-host).

If this is what you do please try 5.23 beta1.  We fixed an issue with forwarded SSH connection and 'copy to other'.

Please describe your connection setup in detail (screenshots are good, but 'fake' the details!)

Actually all connection code is more or less rewritten in 5.23 beta1 – and better I think. So please try it.

 

Actually you can log on as 'root' from 'localhost' (there is always one connection saved for him!) and FLUSH HOSTS.

Also a SQLyog tunnelled connection should work for this (as – again – you connect to MySQL from 'localhost' with a tunnelled connection)

[peterlaursen]

I thought it was HTTP.

This is a webserver issue, I believe. Webserver does neither respond or time out.

[peterlaursen]

Did you try SQLyog/SJA Notifications Service?

You should be able to execute

select imagefile from snf_products where PRODUCT_NUMBER = “10 21020″;' > c:tmp”p308.gif”;

select imagefile from snf_products where PRODUCT_NUMBER = “10 21040″;' > c:tmp”p309.gif”;

etc..

from a Notifications job.

More smart: call Notifications Services recursively from an application that also replaces the PRODUCT_NUMBER and the file name in the jobfile for each 'run'.  I cananot detail it more as I do not know your situation in details and coding skills.

[peterlaursen]

BTW: there is no issue with your mouse?

Again check the USE statements in HISTORY.

[peterlaursen]

Still not reproducable but there is an nonexpected behaviour with the focus in the Object Browser.

Quote:

I was using 1st database for some project, then closed it and clicked on 2nd one, rightclick -> Empty database. it dropped all tables from 2nd database , which is ok. The dropdown on top of program was still showing 2nd database (see note below) and it way selected in treeview. So I clicked on IMPORT (I imported the SQL) but it used 1st database.

Still I have in HISTORY after (see note below):

use `first_database`

…

use `second_database`

.. and import is done to second database as it should

Note:

What we see now is that the focus behaviour is different when the table tree of a database is expanded or not.  Also 'empty database' and 'truncate database' behaves differently.

1) create table `ppp`

2) create table `qqq`

3) let `ppp` be your 'first database' and `qqq' be your 'second database'

What happens at the point of (see note below) in your description is that

4) First expand `ppp` and see that

* if the tree of `qqq` is expanded when emptying it, focus does not change from `qqq`

* if the tree of `qqq` is not expanded when emptying it, focus does change to `ppp`

* with 'Truncate database' focus never changes.

5) Next 'collapse' both `ppp` and `qqq` and repeat.  Now focus changes to the connection.

This was tested with 5.23 beta1.  Your exact version?

Additional questions:

Is this always reproducable or does it only happen from time to time?

Can you see the latest USE statement sent by SQLyog in HISTORY?

Is there a server log that can tell if this USE statement was received by the server?

Connection type and quality?

We had a similar report about 1/2 year ago.  We were not able to reproduce either.  We would very much like to get to the bottom of this – be it a SQLyog issue or not.  Are we missing something?

The old discussion is this one:

http://www.webyog.com/forums//index.php?sh…43&hl=wrong

(a lot of irrelevant posts in here, but it started similar to your issue here)

Please reply to as many questions as you can.  We will then discuss what we can possible do …

[peterlaursen]

However it is still a mystery to me how

Code:

CREATE TABLE `A` (
`B` int(10) NOT NULL auto_increment
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

(auto_increment and no key)

… comes into existence.  When exporting we do a “SHOW CREATE TABLE” statement only.

So this is what MySQL sends – unless you have edited the table?

[peterlaursen]

“the database I am trying to synch with does not contain the table mysql.proc”

If that is the situation with MySQL 5.x, then you have probably upgraded the server from a previous version (and did incorrectly!) and you should absolutely run the “mysql_fix_privilege_tables.sql” script!  You always should when performing a major upgrade of the MySQL server.  Read the MySQL docs on how to upgrade MySQL. But basically you can do this (on Windows):

1) Find the “mysql_fix_privilege_tables.sql” file (in the /scripts -folder).

2) Copy to C:

3) Start mysql command line client

4) Execute “source c:mysql_fix_privilege_tables.sql”

(you cannot use SQLyog because the script generates a lot of errors and SQLyog will abort!)

5) It is consider 'good practice' to 'check/repair tables' after that.  You can do from SQLyog.

The most recent MySQL versions ship with a 'mysql_upgrade' program (in the /bin -folder) that does this automatically.

I cannot tell for sure if this is the porblem here (will need a complete test case).  But with a `mysql` database that has not what tables and columns it should have for a specific MySQL version, we cannot guarantee anything!

[peterlaursen]

“the latest version of SQL Yog”  version number please.  We have seen before that people refer to a 2 year old version as “the latest version” 😉

Please answer:

1) How do you connect to the databases? direct, HTTP, SSH?

2) Does it always happen exactly the same place?

3) How long do you wait?  If you let it 'hang' for several minutes no message will appear?

I have no problems copying +100.000 rows here.

I think chances are that the server becomes irresponsive.  

With cheap hosting and HTTP-tunnelling we have seen a lot of badly configured and 'over-burdoned' webservers. (It is most often a Apache and not a MySQL problem)

But please reply to the questions! 

[peterlaursen]

if you “ALTER TABLE … DEFAULT CHARSET ..” the byte sequence of what is stored is not changed,  And any character that is encoded differently in the two charsets will garble.

All charset setting only take effect with NEW data!

An example: those accented latin characters are stored using two bytes in UTF8, but only one

byte in LATIN*.  

If you have some data stored as UFT8 and “ALTER TABLE … DEFAULT CHARSET ..” every such character will become two (weird) characters!

You can export data to a .sql file, edit this file (and change the server default if you like) and import!

[peterlaursen]

BTW:  does the file use 'full syntax' like

Code:

`database`.`table`

or

Code:

`table`

only when referencing a table?

[peterlaursen]

OK then.

1) Program version please?

2) could you possibly submit a 'test case'?  How to reproduce?

3) When you “select a database” do you then do this by clicking a database in the Object Browser (the left area) or do you use the dropdown combo?

[peterlaursen]

let us se a structure-only dump for the tables and the SQL (from history) what you are trying to do and/or a screendump.

[peterlaursen]

Please try with 5.22 or 5.23 beta1.

and my apology for not having replied before

[peterlaursen]

is there a LETTERCASE mismatch between two tables on the server(s)?

like 'tablename' and 'TABLENAME' ??

We know that this is an issue, but we have not yet quite decided on the future of how to handle such LETTERCASE issues with the SYNC tools.

[Author]

Posts