title: phpMyAdmin export/import results in duplicate primary key error
body: <p>I want to globally replace all instances of my site url in the Wordpress MySQL database with a new site url.  To do that, I'm using phpMyAdmin to export the database to a .sql file, then doing a global replace in a text editor, then using phpMyAdmin to import the .sql file.</p>
  
  <p>During the import, I'm encountering a duplicate entry for primary key error.  Trying to debug this, I exported the file, then imported the identical file, making no changes and I still get the same error.</p>
  
  <p>I appreciate any help solving this.</p>
  
  <pre><code>--
  -- Dumping data for table `wp_comments`
  --
  INSERT INTO  `wp_comments` 
    (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`
    ,`comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt` 
    ,`comment_content`, `comment_karma`, `comment_approved`, `comment_agent` 
    ,`comment_type`, `comment_parent`, `user_id`) 
  VALUES (1, 1, 'Mr WordPress', ''
         ,'http://wordpress.org/', '', '2011-04-28 00:49:55', '2011-04-28 00:49:55'
         ,'Hi, this is a comment.&lt;br /&gt;To delete a comment, 
           just log in and view the post&amp;#039;s comments. 
           There you will have the option to edit or delete them.'
         , 0, 'post-trashed',  '',  '', 0, 0 ) ;
  
  MySQL said: 
  
  #1062 - Duplicate entry '1' for key 'PRIMARY' 
  </code></pre>