I need a php script I can run which does the following. We have 4 servers running master to master replication I will call them A B C D for this question. We have some data that has not replicated fully. So we need a script that will use our server A and connect to each of the other servers.
The script needs to look for fields that are 0.00 or null on server A but on the any of the other servers there is a value. It then needs to copy the value from server B C or D to server A. It's important that it looks for and only copys fields, and not the entire row.
So in a nutshel Server A is missing some data which is on a combination of the other servers. This simply needs to be put onto server A. Once done we will then back this database up and restore on all the other servers.