Select from one host Insert into another
I am volunteering for an election observation agency in Ghana and they are collaborating with an organization that has set-up an Ushihidi (ghvotes2012.org) platform so they can crowdsource incidents during the election. The organization I am working for wants all the incident reports to be stored on a separate server where they can download the data as a CSV.
I have never done something like this so I'm sure I'll have a load a questions, but my first is, what is the best way to query the Ushihidi server, and then put the results onto my organization's server? I looked at replication, but that is an intensive process. What is the best way to go about pulling the data and inserting it somewhere else?