Synchronize the server database with a localhost

Question

Synchronize the server database with a localhost

Navigation

#1 by (0 votes)

-1

I need to synchronize two databases so that their information is the same because of internet instability issues. I found the replication that exists in phpmyadmin, but since I use a cloud server I can not tweak its settings to convert my database into a master

mysql phpmyadmin

asked by anonymous 31.08.2017 / 05:47

1 answer

Method to exchange JavaScript / html images Verification return is sent three times

score 0 · Answer 1

If you can not change the settings of the computer, you can try to make a Linked Server and have a routine in the database "daughter" to from time to time gather information from this Linked Server and put in this new database. Example: Every 1 hour, this information will be entered in the new database. It will not be a real time solution, it will have an information gap, but it can be useful.

Check out this tutorial on how to create Linked Server, it is well detailed: Creating a Linked Server from SQL Server to MySQL - Unused OPENQUERY;