you can do this also (source) (desti) mysqldump -uroot -pxxxx -habc.com --databases yyy --table tab1 | mysql -uroot -p -hzzz.com -Dxxx
On 3/18/09, Krishna Chandra Prajapati <prajapat...@gmail.com> wrote: > > Hi all, > > I am looking for a solution. > > While being on one db server how to get the data from other server. One > method is federated. Is there any other way > > Thanks, > Krishna Chandra Prajapati >
