• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

How can I update remote database over internet?

I am in one server suppose the domain name in www.mysite.com I update some data in www.mysite.com now I want the data should also update in other server at same time over internet which is www.yoursite.com?
0
Tuhin1956
Asked:
Tuhin1956
  • 2
  • 2
1 Solution
 
lpxtechCommented:
You're using mysql correct? You can enable remote mysql on the server that the data will be sent to. If you are using cpanel, Go to Remote MySQL under databases and add the host name of the server that will be sending the data.
0
 
Tuhin1956Author Commented:
I have a jsp page through which I update the database present in  www.mysite.com now I also want to update the databaset in www.yoursite.com at same time. How can I do it?
0
 
Tuhin1956Author Commented:
I have a jsp page through which I update the database present in  www.mysite.com now I also want to update the database in www.yoursite.com at same time. How can I do it?
0
 
lpxtechCommented:
I am not familiar with jsp, but in order to do that, it would be the same as how you update the database for your host. The only difference is, you would open a new connection to the server www.yoursite.com and run your queries to the remote database as well. But you must enable remote mysql to do this.

So, simply enable remote mysql on the remote server, in the scripts that update your local database open a new connection to the remote database. Execute the sql queries to the remote database when you do the local database
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now