title: ERROR 1005 (HY000): Can't create table "x" (errno: -1)
body: <p>I have error coming when i am trying to create tables in MySQL server,</p>
  
  <pre><code>ERROR 1005 (HY000): Can't create table 'bill_period' (errno: -1)
  </code></pre>
  
  <p>Please note this is not same as the "ERROR 1005 (HY000): Can't create table (errno: 150)" (Note that error no is different). </p>
  
  <p>even simple create table fails with this error and Foreign keys are not set and not used. And plenty of disk space is free. </p>
  
  <p>Any ideas ?</p>
  
  <p>for debugging purposes, i have done this same query with the a new table name than the what was originally there, seems to be ok for the second one, </p>
  
  <pre><code>mysql&gt; CREATE TABLE IF NOT EXISTS `bill_period` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `day` tinyint(2) unsigned NOT NULL,   PRIMARY KEY (`id`),   KEY `day` (`day`) );                
  
  ERROR 1005 (HY000): Can't create table 'bill_period' (errno: -1)
  
  mysql&gt; CREATE TABLE IF NOT EXISTS `bill_period_1` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `day` tinyint(2) unsigned NOT NULL,   PRIMARY KEY (`id`),   KEY `day` (`day`) );
  Query OK, 0 rows affected (0.42 sec)
  </code></pre>