How to Synchronize mysql databases between local and hosted servers automatically?

Question

I would like to synchronize local Mysql db with remote Mysql db.

Due to internet fail, we have to use local application. Once internet problem solved, db should synchronize with remote db.

Because we are using same application in local and remote.

http://stackoverflow.com/questions/14661501/synchronize-mysql-remote-local-database-using-phpmyadmin — , Aug 21 '13 at 07:12
http://stackoverflow.com/questions/52583/best-tool-for-synchronizing-mysql-databases — Sathish D, Aug 21 '13 at 07:18

score 2 · Answer 1 · answered Aug 21 '13 at 07:15

2

You can use SQLyog which has Database synchronization feature to sync two databases if you are looking for open source tool then refer pt-table-sync http://www.percona.com/doc/percona-toolkit/2.1/pt-table-sync.html

answered Aug 21 '13 at 07:15

Mahesh Patil

score 0 · Answer 2 · answered Aug 21 '13 at 07:12

0

You can make the dump of your local database, and import that on the hosted server when ready.

answered Aug 21 '13 at 07:12

Sahil Mittal

score 0 · Answer 3 · edited Jun 02 '21 at 18:47

I think I would create a table changes on a local database and whenever I do any change on the database, it is also saved in the changes table.

For synching then, I'd

Of course, here intensive validation should be considered to ensure that the pasted text is a query string copied from the local server

score -2 · Answer 4 · answered Aug 21 '13 at 07:12

-2

I am afraid you need to do the export and import thing. Don't think there is any automatic kind out there..erm, i would like to know as well

answered Aug 21 '13 at 07:12

Philip Tiong

4 Answers4