Solved

How can I update remote database over internet?

Posted on 2008-11-01
5
453 Views
Last Modified: 2012-05-05
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
Comment
Question by:Tuhin1956
  • 2
  • 2
5 Comments
 
LVL 6

Expert Comment

by:lpxtech
ID: 22856203
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
 

Author Comment

by:Tuhin1956
ID: 22856289
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
 

Author Comment

by:Tuhin1956
ID: 22865103
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
 
LVL 6

Accepted Solution

by:
lpxtech earned 250 total points
ID: 22865139
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Using Quotation Marks in PHP This question (http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28217211.html) seems to come up a lot for developers who are new to PHP.  And it got me thinking, "How can we explain the rule…
A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Wufoo.com provides powerful tools for surveying targeted groups, and utilizing data from completed surveys to find trends, discover areas of demand or customer expectation, and make business decisions on products or services.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now