title: MySQL database merge of two databases
body: <p>I set up two Wordpress blogs a while ago, both obviously having different databases. I've more recently merged these databases into one by changing the tables prefixes, therefore these two 'entities' have the same amount of tables and the same names (as they originate from a Wordpress install) but with different prefixes, i.e.:</p>
  
  <p>Blog1_tabledata1<br/>
  Blog1_tabledata2<br/>
  Blog1_tabledata3<br/>
  Blog1_tabledata4<br/>
  Blog2_tabledata1<br/>
  Blog2_tabledata2<br/>
  Blog2_tabledata3<br/>
  Blog2_tabledata4</p>
  
  <p>I have now realised that I need to merge these two databases (where they're both using the same tables) so that they can be used in the same Wordpress instance (later separated by tags etc).</p>
  
  <p>What would be the most simple way of doing this?</p>
  
  <p>(Please note I am asking this from a MySQL standpoint - this is not a Wordpress question!)</p>