Extract missing MySQL Data from 2 servers and compare.

Job ID: 33445344

Budget: $30 – $250 USD

Hi,

Let me explain the scenario.

We have 1 Master and 2 Slave Mysql Replication environment.

Few days ago, 1 of the slave having problem and we have to start the mysql and recover from the logs that is fine.

So there are few hundreds of data missing in between 2 servers.

I would like to hire a freelancer. To compare between 2 database and extract the missing database so that i can reimport it back to the Mysql Slave that do not have complete database.

The comparison date should be from beginning of May 2021 until 10th April 2022.

Attached is the 6 databases that we need to compare between servers. Each database having 20-30 tables.

We need freelancer to generate script to export only data that is not available in the problematic slave server.

That data then should be able to be imported to the problematic slave without any problem.


Thank you.