Solved

How can I update remote database over internet?

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Thoughout my experience working on eCommerce web applications I have seen applications succumbing to increased user demand and throughput. With increased loads the response times started to spike, which leads to user frustration and lost sales. I ha…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
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.

828 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