title: Mysql import error - #1005 - Can't create table , (errno: 140 "Wrong create options")
body: <p>I am attempting to transfer a site from one server to another, and am having trouble importing the database to the new server via phpmyadmin. When I import, I get the following error: </p>
  
  <p>Error
  SQL query:</p>
  
  <pre><code>--
  -- Database: `prycisio_ctfadata`
  --
  -- --------------------------------------------------------
  --
  -- Table structure for table `ctf_audit`
  --
  CREATE TABLE IF NOT EXISTS `ctf_audit` (
  
  `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `tableused` VARCHAR( 45 ) DEFAULT NULL ,
  `idref` INT( 10 ) UNSIGNED DEFAULT NULL ,
  `entry_date` DATETIME DEFAULT NULL ,
  `entry_user` INT( 10 ) UNSIGNED DEFAULT NULL ,
  `entry_browser` TEXT,
  `entry_ip` VARCHAR( 16 ) DEFAULT NULL ,
  `entry_session` TEXT,
  `altid` INT( 10 ) UNSIGNED DEFAULT NULL ,
  `entry_data` TEXT COMMENT 'other user data',
  `checkhidden` VARCHAR( 255 ) DEFAULT NULL ,
  `entry_type` VARCHAR( 45 ) DEFAULT NULL ,
  PRIMARY KEY ( `id` )
  ) ENGINE = INNODB DEFAULT CHARSET = latin1 ROW_FORMAT = DYNAMIC AUTO_INCREMENT =519;
  
  
  
  MySQL said: [​IMG]
  
  #1005 - Can't create table `prycisio_ctfadata`.`ctf_audit` (errno: 140 "Wrong create options")
  </code></pre>
  
  <p>I'm afraid I don't really know what I am looking at here. Can anyone help me with a solution?</p>
  
  <p>Thanks</p>