Synchronize the server database with a localhost

Asked

Viewed 289 times

-1

I need to synchronize two databases so that the information of both are equal due to problems of instability of the internet. researching found the replication that exists in phpmyadmin, but as I use a cloud server I do not well tamper with its settings to convert my database to master

mysql phpmyadmin replication

1 answer

0

If you can not change the settings of the computer, you can try to make a Linked Server and have a routine in the "daughter" database 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 injected into the new base. It will not be a real time solution, it will have a gap of information, but it can be useful.

Check out this tutorial on how to create Linked Server, it is very detailed: Creating an SQL Server Linked Server for Mysql - Not using OPENQUERY;

Browser other questions tagged mysql phpmyadmin replication

You are not signed in. Login or sign up in order to post.