title: Copying data from one table to another table. Databases are different and table structure is different
body: <p>I am looking for a solutions for my MySQL data copying related problem. 
  I have a table TAB1 in a database DB1 that contains some data. Now I want some of these data rows to be migrated to another table TAB2 to some another database DB2.</p>
  
  <p>What would be an ideal way to write such a SQL script for MySQL server. I cannot write java/php program etc because I don't have access to the code base.</p>
  
  <p>Any example links will be helpful. I know this can be done in Oracle via DBLink but how to do it in MySQL.</p>
  
  <p>Thanks</p>