I gang

MySQL sync tables from replication issue

Hi,

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.

Thanks

Andrew

Færdigheder: MySQL, PHP, SQL

Se mere: mysql sync tables, php script null, sync tables mysql php, mysql sync replication, row b, replication, null, mysql copy, Data tables, Andrew, sql database sync, php sync, mysql running, sql question, php connect sql server, php connect mysql, sync data, SQL Data Sync, sql server replication tables, sync mysql database, connect database mysql, database replication mysql, sync sql server, mysql copy database, copy tables

Om arbejdsgiveren:
( 0 bedømmelser ) bolton, United Kingdom

Projekt-ID: #929277

3 freelancere byder i gennemsnit $47 for dette job

RedhopIT

[url removed, login to view] Check PM

$50 USD in 0 dage
(63 bedømmelser)
6.1
websolution1992

Hello sir! I am ready to start your project. Please refer your pmb. Thanks.

$30 USD på 1 dag
(3 bedømmelser)
2.4
imranfree

Hello sir! I am ready to start your project. Please refer your pmb. Thanks.

$60 USD in 3 dage
(1 bedømmelse)
0.0