I have local MySQL database which changes occasionally, when it changes I want to synchronize it with Remote database. I am using PhpMyAdmin's synchronize option for it.
I have given permissions to all IP to connect remotely.
Problem:
When I want to synchronize remote database with local database using synchronize option of PhpMyAdmin. It only shows the database structure difference but data is also different on both the databases but it is not showing that difference.
And when I synchronize the database by clicking Synchronize Database
button and again do synchronization. It again shows same structure synchronization.
See image below
If anyone have alternate solution for it please also tell that.
Local Details
OS: Windows7
Software: EasyPHP12.0
Remote Details
Server: Linux Cpanel
PhpMyAdmin
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…