two way sync work fine, one sync not

[Anonymous]

i've two server that must be syncronized.

a part of tables need a one way sync from local to web server.

other tables need a two way sync because the data are updatable from local DB and from web server DB.

i configure an xml file for SQLyog Job Agent to sync on one way and….

if i update local table the web server table is updated corractly, when i delete a local record the web server table is updated correctly,

but when i added a new record in local table… when i try to syncronize… the new record is addend and deleted at the same time.

i don't understand the reason of that.

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

articoli 4095 4094 1 0 1

articoli_categorie 4858 4858 0 0 0

if modify the xml config file and i put twowaysync true,

the item is added correctly…

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

articoli 4095 4094 1 0 No change

articoli 4095 4095 0 0 No change

articoli_categorie 4858 4858 0 0 No change

articoli_categorie 4858 4858 0 0 No change

you can say the reason of that?

thanks Michele

[Ritesh]

We are working on your issue and will revert back soon.

[Ritesh]

Which version of MySQL and SQLyog are you using?

Can you mail me your table structure and some sample data?

[jfgreco]

Anything on this one? I seem to notice the same problems with one way sync local to web.

[Ritesh]

Quote:

Which version of MySQL and SQLyog are you using?

Can you mail me your table structure and some sample data?

Without sample data we are not able to reproduce the error 🙁

[jfgreco]

Contact me and I will supply with data.

At the present momemt I am running a one way sync. From my local to my web server. And it Updated, Inserted and now it is deleting everything in the database.

[Author]

Posts