From: Ananda Kumar Date: March 18 2009 2:07pm Subject: Re: Remote data List-Archive: http://lists.mysql.com/mysql/216786 Message-Id: <829b199c0903180707v542c8251va9e37ed3acb1108c@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e645a47c682cd10465653591 --0016e645a47c682cd10465653591 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 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 > --0016e645a47c682cd10465653591--