title: Table already exists error when trying to import sql file
body: <p>I am trying to upload a backup sql file through phpMyAdmin.</p>
  
  <p>create the empty db with the same db name as in my import file in phpMyAdmin then use the import function selected from within this empty db.</p>
  
  <p>I get the following error message.</p>
  
  <pre><code>#1050 - Table '`db`.`t`' already exists 
  </code></pre>
  
  <p>Inside the import file each <code>CREATE TABLE</code> statement is suffixed by <code>IF NOT EXISTS</code>, so why is this being reported as an error?</p>
  
  <pre><code>    --
  -- Database: `mbfour`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cars`
  --
  
  CREATE TABLE IF NOT EXISTS `cars` (
    `car_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    `type` varchar(200) NOT NULL,
    `status` varchar(20) NOT NULL,
    `capacity` varchar(5) NOT NULL,
    PRIMARY KEY (`car_id`),
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  
  --
  -- Dumping data for table `cars`
  --
  
  INSERT INTO `cars` (`car_id`, `type`, `status`, `capacity`) VALUES
  (1, 'automatic', 'built', '4L'),
  (2, 'automatic', 'in-production', '2L'),
  (3, 'automatic', 'built', '2L'),
  (4, 'automatic', 'in-production', '4L');
  ....
  ....
  </code></pre>
  
  <p>Is There Any Magic Happens???</p>
  
  <p>After Trying Two Times Then I Import like same Way, It works</p>
  
  <p>Thanks Folks.....</p>