title: What is the best way to merge 2 MySQL data dumps?
body: <p>We have built an application with MySQL as the database. Every week we export the data dump from the database, and delete all the data. Now we want to merge all these dumps together for some data-analysis tasks.</p>
  
  <p>The problem we are facing is that the "id" field for all the tables is Auto-Increment, so it starts with 1 in all the data dumps, which causes duplicate IDs in the table. I am sure there must be better ways to do it since it should be a pretty common task in MySQL administration.</p>
  
  <p>What would be the best way to go about it?</p>