[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

[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.

[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

[Author]

Posts