如何同步2个MySQL数据库？ [英] How do I sync 2 MySQL databases?

问题描述

我写了一个程序来使用一个MySQL数据库，我的网站，我最近买了一些经销商托管，但托管公司限制了共享服务器上的外部访问，所以我要在另一个设置一个外部mySQL数据库服务器，但是为此我需要一个PHP文件在我的经销商服务器上，可以连接到本地数据库和远程数据库，并通过URL通过应用程序的请求同步它们。

I written a program to work with a MySQL database that powers my website and I have recently bought some reseller hosting however the hosting company has restricted external access on the shared server, so I was going to setup an external mySQL database on another server that can be accessed remotely, however to do this I need a PHP file on my reseller server that can connect to the local database and the remote database and sync them on request from the application via a url.

有没有人知道最好的方法实现这个？

Does anyone know the best method achieve this?

推荐答案

尝试使用 SQLyog的数据库同步工具

这篇关于如何同步2个MySQL数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！