I have a classified site (Site A) running on PHP/MySQL. In this I have a usertable which I want to be copied to the usertable in Site B, also a classified site. Both are in MySQL. Specifically, I want to keep site B table synchronized with Site A table. Users will only be added / edited through Site A. When there is a change/add in Site A table, it should be reflected in Site B table. This could be set to happen whenever the records are updated/added (by admin or site user) or as a cron job once a day. The fields that need to be kept synchronized are:
in addition, the site B table has some extra fields that need to be filled with some dummy values (secret question field and secret answer field - encrypted)
Only user records that meet a certain criteria will be kept synchronized. This is a simple criteria based on two fields in the user table.