Moving Data Between Servers

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
WanamakerStudios
Forum Commoner
Posts: 65
Joined: Thu Nov 30, 2006 7:35 am

Moving Data Between Servers

Post by WanamakerStudios »

I have one central server that I receive a database feed on. I also have a secondary server that I would like to export some of that data to. How can I create a statement that would select certain records from one DB on one host and insert it into another DB on a different host?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Either set up replication, or create an intermediary that connects to both servers transferring data as needed.
Post Reply