Problem: Sqlyog Inserts Then Deletes

[Richard Mayer]

Hi,

I wonder if someone can help me. I am experiencing a little difficulty with a MySQL Table to MySQL Table synchronisation, using the tool within SQLyog v5.22. When doing a one way synchronisation (a simple replication) between two tables, it works fine the first time, but subsequent executions seem to, for a handful of rows, do an INSERT and then immediately, with the same number of records, do a DELETE. As I say, it is not the whole table that does this and only perhaps 1100 rows in 18000. Any ideas? I understand that I may need to give table samples etc, but was hoping it could something people are familiar with in SQLyog.

Environment

Windows 2008 Server R2 32 bit

MySQL 5.1

SQLyog Enterprise – MySQL GUI v5.22

Many thanks.

Richard

[peterlaursen]

I think I remember that this is a bug that has been fixed long-long ago.  5.22 is now almost 4 years old and we cannot possibly support it.  Please try a recent version (if you want to verify you may use the latest TRIAL with that specific table)

[Richard Mayer]

Thanks for your advice. I will buy an upgrade.

[Author]

Posts