Depending on what you mean by 'Calculate the data', you could try using a tool like Talend (www.talend.com).
> What exactly do you want to calculate? > > Generally, export (mysqldump cmd) and import (mysql cmd) of data is done > as > below: > > Supposing "japan" is the source db and "usa" is your destination db, > > 1) Dump the database on source server: > > $ cd <to dir where you have enough space to take the dump> > $ mysqldump -u<user> -S<socket file path> -p<password> japan > > ./source_japan.dbdmp > > 2) ssh to destination host > 3) Check if that folder is shared between remote and local host. else, > Step4. > 4) scp the dump file from souce host to destination host: > > $<path_to_scp> > <username>@<souce_hosts_ip_addr>:<path_to_source_japan.dbdmp><username@<souce_hosts_ip_addr>:<path_to_source_japan.dbdmp>> > <path_to_where_space_is_available_on_local_host> > > 5) Import the dumpfile to destination db: > $ mysql -u<user> -p<password> -S<socket file path> usa < > ./source_japan.dbdmp > > > Regards, > Uma > > > On 6/25/09, 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=bhat....@gmail.com >> >> > > > ______________________________________________ > This email has been scanned by Netintelligence > http://www.netintelligence.com/email > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
