u asking any scripts On 6/25/09, John Daisley <john.dais...@mypostoffice.co.uk> wrote: > 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=bharanikumariyer...@gmail.com > >
-- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
