Reputation: 16
I have a local database and a main database, both in mysql. The local db is being updated and the data being sent to the main db whenever there is internet. The main db is also being updated . How can i synchronize data between the local site and the main server?
Upvotes: 0
Views: 62
Reputation:
Try to use one database instead two databases, in local development you may use ssh tunnel:
ssh -f -N -L 3333:192.127.48.160:5432 yoursite.com
Upvotes: 1