title: MySQL: Can't create table (errno: 150)
body: <p>I am trying to import a .sql file and its failing on creating tables.</p>
  <p>Here's the query that fails:</p>
  <pre><code>CREATE TABLE `data` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `value` varchar(15) NOT NULL,
  UNIQUE KEY `id` (`id`,`name`),
  CONSTRAINT `data_ibfk_1` FOREIGN KEY (`id`) REFERENCES `keywords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;    
  </code></pre>
  <p>I exported the .sql from the same database, I dropped all the tables and now im trying to import it, why is it failing?</p>
  <blockquote>
  <p>MySQL: Can't create table './dbname/data.frm' (errno: 150)</p>
  </blockquote>