title: Can I merge two databases into one in Mysql if they both have the same schema?
body: <p>I have two databases in MySQL that already have data. they have exactly the same schema. I would like to merge those two databases into one only. I tried:</p>
  <pre><code>mysqldump -u root -p --databases database1 database2 database3 &gt; database1_database2_da
  </code></pre>
  <p>However, when I try to open <code>database1_database2_da</code>, I only end up with data from one of the database, but not all of them. I also want to mention that the two databases have their records starting at 1, since they are automatically generated. Do you think there is a way to merge those two databases without losing data from any of them?</p>