inserting records from mysql table on remote database

Mar 12, 2012   //   by phpfreelancer.biz   //   Blog, MySQL Tutorial  //  No Comments

I have two databases on two different servers, i wish to insert the records from table A on server2 to table B on server1, table A and B have identifical schema but different names. how can this be done?

The Easiest approach as per my point is make .sql file from first server db.

Now Open that .sql file in note and find & replace the table name A with table name B.

Now execute that .sql file on the remote server 2.

Leave a comment

Share This Post

RSS Wordpress News