title: Copy Data From One Database To Another In Same Table
body: <p>I want to copy data from one database which has table named domains to another database which also has the table named domains to it.</p>
  
  <p>I have tried doing it using phpmyadmin but it doesn't copy maybe because of Auto_increment values. it just doesn't get copied to another database.table.</p>
  
  <p>I want to know what can be done in this regard? also I don't want to copy old ID(auto_increment) values from first database to another.</p>
  
  <p>phpmyadmin response.</p>
  
  <pre><code> #1136 - Column count doesn't match value count at row 1 
  </code></pre>
  
  <p>both the structures are same in the databases still this.</p>
  
  <p>My Query.</p>
  
  <pre><code> INSERT INTO `site1`.`domains`
   SELECT * FROM `site33`.`domains` 
  </code></pre>
  
  <p>^ This much is fixed.
  now comes the auto_increment problem I Get:</p>
  
  <pre><code>  #1062 - Duplicate entry '1' for key 'PRIMARY' 
  </code></pre>