title: How to copy a table from one mysql database to another mysql database
body: <p>I need to copy a table from one database to another. This will be a cronjob. Which one is the best way to do it? PHP script or Shell Script. The problem with PHP, both databases has different usernames and passwords so I can't do it like this.</p>
  
  <pre><code>CREATE TABLE db1.table1 SELECT * FROM db2.table1
  </code></pre>
  
  <p>Should I just connect first DB get all records and insert all to new database using WHILE loop or there is a better way?</p>
  
  <p>I prefer a shell script to do this instead of PHP script.</p>
  
  <p>Thanks</p>