Harvey
Harvey

Reputation: 57

How do I sync 2 MySQL databases?

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?

Upvotes: 0

Views: 13472

Answers (1)

Sandy
Sandy

Reputation: 1053

Try using SQLyog's Database synchronization tool

enter image description here

Upvotes: 4

Related Questions