Basically I am trying to retrieve, insert and update data between two different MySQL servers, one on the localhost and the other remotely-hosted.
How is this done?
Does it change the way in which you make a query?
Any information appreciated.
You just need a second connection to the second server.
Alternatively if you're using MySQL 5.1 or above on the local one (which is not yet generally available - it's in Beta), you could use a FEDERATED table type (see the docs for more info).
Mark
