title: PHP/MySQL: Copy Table and Data from one Database to another
body: <p>Anoter question: What is the best way to copy a whole table from one Database without using something like this:</p>
  
  <pre><code>CREATE TABLE DB2.USER SELECT * FROM DB1.USER;
  </code></pre>
  
  <p>This does not work because I can't use data from two Databases at the same time. So I decided to make this with php. There I had to cache all Data and then I'd create a table in the other DB.</p>
  
  <p>But now - what would be the fastest way to cache the data? I guess there are closely everytime less than 1000 records per table.</p>
  
  <p>Thanks for your input</p>