Solved

How can I update remote database over internet?

Posted on 2008-11-01
5
454 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A Change in PHP Behavior with Session Write Short Circuit (http://php.net/manual/en/book.session.php#116217) (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

867 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