title: Copy a mysql table content from one server to another server
body: <p>How to copy a table from server <strong>A</strong> database <strong>db1</strong> to server <strong>B</strong> database <strong>db2</strong> ?</p>
  
  <p>I am able to copy a table from one database to another database within the server, but not able to do for across servers. </p>
  
  <pre><code>CREATE TABLE recipes_new LIKE production.recipes; 
  INSERT recipes_new SELECT * FROM production.recipes;
  </code></pre>
  
  <p>The whole thing I am doing it to reduce the server load so that I can copy table info into another server and run my queries there...</p>