daya synchronization deletes information

[kevin5758]

I have used SQLyog for some time and it seemed to work fine, even thought I got — “Warning: Source and Target MySQL versions are not matching.” At that time, the hosting company mysql version was 3.something.

It appears our hosting company has installed a new version of mysql. ( 4.0.20-standard)

Below is a copy of the Warning message I recieve.

Warning : Source and Target MySQL versions are not matching.

Source : 4.0.12-max-nt, Target : 4.0.20-standard.

SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.

Now I find the Data Synchronization Wizard deletes data from some tables when I sync. Is there something I can do to correct this problem?

thanks

kevin

[Shadow]

If there are such rows in the target db that are not present in the source db and you chose to perform a one-way sync, then sja deletes these extra rows.

[kevin5758]

Thanks for the reply.

The two tables in question are identical. I conducted this test to double check. I used phpMyAdmin to copy the source table and all data to the target location. (copied from local machine to server)

Then I used the Data Synchronization Wizard again, and it still deletes information. Below are details.

Table SrcRows TgtRows Inserted Updated Deleted

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

`fork`- 88

---

88

---

0

---

77

---

77

[Ritesh]

Which version of SQLyog are you using?

Can you send us a sample of your data so that we can test it out here and fix the bugs (if there are any)?

[kevin5758]

I am using v 3.71.

I can send data, if you tell me exactly what you want. i.e. Do you want a .sql copy of the table that causes the trouble. And where do I send it.

[Ritesh]

Ok.

We have fixed number of bugs regarding SJA in SQLyog 4.0.

Download the latest BETA from http://www.webyog.com/sqlyog/SQLyog40.exe and install it. Run the sync tool and check if the problem persists.

If the problem still exists, then you have to send me backup of your source database and target database. You can generate the .sql files for these databases through DB->Export Database As Batch Script option.

More information about SQLyog 4.0 can be found at:

http://www.webyog.com/forums/index.php?act…st=0&#entry3707

[kevin5758]

I downloaded and used 4.0. I can still re-create the same problem as before. (deleting records in Target database)

However, I had been leaving the check box “Don't delete extra row(s) in Target database” UNCHECKED. I reasoned that if both tables had the same number of rows and record_id's, there would be no deletion.

Next I tried sychronizing the two databases, but CHECKED the box. With the box checked, it did not delete any records.

Guess I'll always check the box.

Thanks

Kevin

[Author]

Posts