Updating mysql localhost database from remote server

Question

I have two tables with same rows and columns one is on my localhost and second is on a remote server.

What I want is that if some one will add any data to my online remote server it should make an entry automatically to my localhost database.

Is there any way to use a trigger or anything else I can do..

Are you able to use replication? dev.mysql.com/doc/refman/5.0/en/replication.html — webbiedave
– webbiedave, Commented Jul 25, 2011 at 18:39
Have a look at dev.mysql.com/doc/refman/5.1/en/federated-description.html — rabudde
– rabudde, Commented Jul 25, 2011 at 18:40

Wrikken · Accepted Answer · 2011-07-25 18:41:25Z

1

You are looking for Replication. Note that you could do it with a FEDERATED table, but that is extremely slow at best, and should not be used because of both reliability & performance reasons.

answered Jul 25, 2011 at 18:41

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonathan Over a year ago

thanks wrikken so is there any other way apart from replication...?

Wrikken Over a year ago

Not a reliable one that I know of. You could fiddle about with some custom build udf's, but really, replication is what you want (and can be easily implemented on any VPS or server, but on shared hosting it's probably a no go).

k4t434sis · Accepted Answer · 2011-07-25 19:22:56Z

0

You may want to set up a cron job on your server that executes a php script that checks for new rows in your remote database every few minutes and adds them to the local database.

answered Jul 25, 2011 at 19:22

k4t434sis

5194 silver badges17 bronze badges

Collectives™ on Stack Overflow

Updating mysql localhost database from remote server

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related