title: How to dump data from one table and insert to another
body: <p>I have two databases. I want to dump data from one table in 1st database and insert to another table with an another name in 2nd database.<br/>
  So I have DB1 that has tables tbl1 and tabl2, and DB2 that has tables tbl3 and tbl4. I know that tabl1 and tabl3 have the same structure. How to copy data from one to another by using mysqldump command?<br/>
  I've tried to do this, but it's not work.</p>
  
  <pre><code>mysqldump --user root --password=password --no-create-info DB1 tbl1 &gt; c:/dump.sql
  mysql --user root --password=password DB2 tbl3 &lt; c:/dump.sql
  </code></pre>