On Thu, Feb 10, 2011 at 10:42 PM, Chandrashekar Babu <[email protected] > wrote:
> On 10/02/11 4:33 PM, JAGANADH G wrote: > > Is it possible to quary and fetch data in one mysql db and store it in a > > second on . > > > > I have machine M1 and M2 with mysql configured . There is a DB in M1 > namely > > employee_details . Now I have to fectch all the recods in M1 > > employee_details from and have to store M2 mysql database via mysql > query. > > You might want to try using mysqldump as mentioned by Sathia. > > This also works. create the database in M2 login to M1 mysqldump -a *dbname *-u *user *-p*password* | ssh *user*@*xxx.xxx.xxx.xxx*mysql -u *user* -p*password* *dbname* Raju _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
