How to see the changes of a local DB against Server DB, if they are in sync? And how to sync them from time to time? no 3rd party tools - 【StackMirror】|php|mysql|sync|local-database

A continuation to Sync large local DB with server DB (MySQL), how can we see the differences between a local DB and server DB, before we go for syncing them?

I dont want to use any third party tools.

2012-04-04 05:06
by tuxnani

Have a look at Schema and Data comparison/synchronization tools in dbForge Studio for MySQL. There are also separate tools for data and schema comparison.

2012-04-04 06:45
by Devart

I dont want to use 3rd party tools - tuxnani 2012-04-11 10:10

On the one server you can write a query to find changes (data and even schema). But when two servers have to be compared, the third party tool may be very helpful - Devart 2012-04-11 10:28