?
Solved

How can I update remote database over internet?

Posted on 2008-11-01
5
Medium Priority
?
459 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

752 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