title: If you load a dump file into a table with an auto_increment column, what happens?
body: <p>Assume I have a <code>reports</code> table with an <code>id</code> int auto_increment column that serves as the primary key.</p>
  
  <p>If I <code>mysqldump</code> this table into a file with <code>drop table</code> and <code>create table</code> instructions added, and then I load it into another database B which is just like A but missing a few of the newest <code>reports</code> records, does database B end up with an exact copy of database A's <code>reports</code> table? </p>
  
  <p>what if the <code>drop table</code> and <code>create table</code> instructions were missing?</p>