Hi I think you mean that you want to get some results (by calculating the data in remote database) and then stock them in local database; so dosen't need to dump the db and transfer to local,but need to do some program to fetch the result and insert into the local database; In addition, like John said, you can try to use Talend or Kettle to avoid the coding part.
On Thu, Jun 25, 2009 at 7:12 AM, Nathan Huang <nathan.vorbei.t...@gmail.com>wrote: > Hello > I want to fetch and calculate the data from remote database(for example > Japan) and insert them into my local database(for example usa), does mysql > have such function to do it, or do I have to write a script using perl or > other language to help achieving it? > thank you in advance > nathan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=franks1...@gmail.com > > -- ------------------------- Lin Chun