Hello Nathan,
Nathan Huang 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
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 s
u asking any scripts
On 6/25/09, John Daisley 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
>
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
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
$ mysqldump -u -S -p japan >
./source_japan.dbdmp
2) ssh t
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
