title: MySQL CREATE TABLE IF NOT EXISTS in PHPmyadmin import
body: <p>I have the following code</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `abuses` (
    `abuse_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL DEFAULT '0',
    `abuser_username` varchar(100) NOT NULL DEFAULT '',
    `comment` text NOT NULL,
    `reg_date` int(11) NOT NULL DEFAULT '0',
    `id` int(11) NOT NULL,
    PRIMARY KEY (`abuse_id`),
    KEY `reg_date` (`reg_date`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Table with abuse reports' AUTO_INCREMENT=2 ;
  </code></pre>
  
  <p>this table already exists in the database, but when i import an sql file with phpmyadmin, the following error occurs</p>
  
  <pre><code>--
  -- Dumping data for table `probid_abuses`
  --
  INSERT INTO  `abuses` (  `abuse_id` ,  `user_id` ,  `abuser_username` ,  `comment` ,  `reg_date` , `auction_id` ) 
  VALUES ( 1, 100020,  'artictundra', 'I placed a bid for it more than an hour ago. It is still active. I thought I was supposed to get an email after 15 minutes.', 1338052850, 108625 ) ;
  
  #1062 - Duplicate entry '1' for key 'PRIMARY' 
  </code></pre>
  
  <p>i thought because it already exists it won't attempt to create it, why is it behaving as such?</p>