[peterlaursen]

I am sorry for the short reply in the first place.

We were not good at the time to 'keep track' of issues.

It is better now!

Implementation idea:

At intervals send a 'dummy query' like

Code:

SHOW VARIABLES LIKE 'keep me alive';

that will of course return NULL 😀

The tricky part of it is the TIMER functionality. I think there will have to be a seperate thread running for each open connection. These threads should SLEEP most of the time, but WAKE UP – say – every 2 minutes, check HISTORY if anything was sent since since last wake-up. If there was not then send the dummy statement.

I also think that this should be optional/configurable (I have no such issue and do not need the feature). I do not know of other database clients doing things like this. There is no FTP-like 'NOOP' command available in SQL. No 'ping' either (you can ping the host, but not MySQL). However I think that PHP has a mysql_ping() function. Anybody knows what it actually does?

[peterlaursen]

I think you are the only person having experienced/reported this! We cannot reproduce.

Please try 5.2 beta5 when available (tomorrow likely).

There were some stability issues fixed.

Unless it is somehow related to 'autocomplete' it should not matter if it is COMMUNITY or ENTERPRISE version.

[peterlaursen]

@uyuni:

It works for me with the latest internal build from:

http://www.webyog.com/downloads/betas/not_…SQLyog52Ent.exe

(beta5n = beta 5 not_yet_released)

[peterlaursen]

thanks for teaching!

I have never heard of such issue before. I use SQLyog wtih Wine on Suse 10.0 and 10.1 regurlarly. I also briefly tried it on Fedora5. And no other user reported this with different distros (DEBIANbased, RH/CentOS, Slackware).

Do you have an idea if it is a Kubuntu, a Wine or a SQLyog issue ??

[peterlaursen]

We will definitely look into this tommorrow!

We will 99% also release beta5 tomorrow ourselves. It will probably be too late to include your patches in this one (I hope that there is not too much 'crossover'). But they can go into RC1 ..

I shall ask Manoj about the diff's are an OK way o coomunication or there is some better method.

To submit patches yourself to Google you will have to be a 'project member'.

[peterlaursen]

From tools .. preferences .. editor you must choose a font that has support for cyricllic. And choose the cyrillic script in the dropdown too.

We have added more fonts controls in 5.2. Expect beta5 today or tomorrow.

http://webyog.com/faq/33_7_en.html

We have a FAQ:

http://webyog.com/faq/34_102_en.html

If data are stored as uft8 or ucs2 and you have an English Windows localisation you must choose a non-unicode russian charset in the connectisons manager and select russian a default for non-unicode programs.

[peterlaursen]

There is no such option.

[peterlaursen]

I do not know what 'strace' is! stack-trace?

I usually use KDE. From KDE I rightclick the .exe .. 'open with' .. wine. Check the box that 'exe's shall allways be executed by wine.

For the future I only need to click an/any .exe and it is opened by wine!

[peterlaursen]

Please try to upgrade to 5.19.

[peterlaursen]

I am sorry – did not notice that you wrote the wine version.

hmmm… need to think about this ….

[peterlaursen]

please inform about the Wine version!

execute “wine –version” from a command shell.

I have no such issue with Wine 0.9.13+ on SuSE 10.0 and 10.1

[peterlaursen]

Thank you very much for the info!

I'll keep an eye on that bug report!

Whenever you get convinced that this is the issue, I think you should add this info to the bug report at mysql.com!

[peterlaursen]

Yes .. we know some possible reasons for this!

Rows are inserted because a PK-value exists on source but not on target.

But they get deleted again on target if checksums for a particular row differ. That can occur:

1) With PK's based on a TIMESTAMP, DATETIME or similar

It is basically a MySQL 'documentation bug'

refer to: http://webyog.com/faq/35_104_en.html

It should work with most recent SQLyog versions now.

2) With PK's build on strings that have certains special characters in them (baskslash, apostrophe, backtick). Those were SQLyog bugs fixed quite a long time ago (most of them way back in 4.07 actually). There has also been an issue with non-ascii characters and HTTP-tunnelling. Don't remember exactly when that was!

3) When tables is having different character sets (and typically when there are strings containing non-ascii-characters).

This is not a bug! For instance accented latin characters like ä. é. ø, ñ are encoded using one byte in latin1 and 2 bytes in utf8. If one of your tables use each their charset like this the md5(concat_ws(your_data)) will return different values on the hosts. Charsets must (in principle – there may be a few special characters that sync OK across latin1/latin2/latin5 for instance) be identical in tables that are sync'ed.

4) There are one or more issues with UCS2 charset too ..

http://webyog.com/faq/35_112_en.html

Please answer:

1) What is the SQLyog version that you use?

2) If the above does not explain and a SQLyog upgrade does not fix this then please post the table schema with a few rows of data to reproduce.

3) Also inform about the MySQL server version(s) and the connection method! In particular if you are HTTP-tunnelling or not?

[peterlaursen]

@toma

Please only ask the same question once!

[peterlaursen]

As I wrote I cannot tell for sue what is happenning.

But we never had any similar report.

It is a possibility that some Windows thing got messed up somehow on that PC of yours.

[Author]

Posts