Regarding DB Link in MYSQL

[kuppurao srinivasan]

Hello,

Appreciate your feedback.

I am looking for some info related to Database Link in MYSQL similar to the one in ORACLE.

1.If I want to transfer data from one server to another server, how do i do it MYSQL
2.In case of a query needs access to other databases, how do i do it in a query.
ie (select a.col from table a, table1@dbserver b where a.col = b.col).
3.In Case of transferring the data to the other database server(like From MYSQL database to ORACLE Database), what method should be adopted.
ie(insert into tab@dbserver select* from table1;)

I need it very urgently these info.

Pls advice on this.

Thanks
Srini