title: Mysql 'Got error -1 from storage engine' error
body: <p>I have a myism table 'test' which holds some out-dated data, now I want to recreate the table, all columns the same except that I changed the storage from myism to innodb. The dumped sql I used to recreate the table is like:</p>
  
  <pre><code>drop table test;
  create table test ( ... )
  engine=innodb
  
  insert into test(...) values(...)
  </code></pre>
  
  <p>that's where I got the error "Got Error -1 from storage engine", I have googled around, most of the results focus on corrupted innodb tables. While for my case I don't think it's broken, it's just something I missed at the drop and create statements. </p>
  
  <p>Another thing is that is after a executed the above sql, all that's left for table test is a file named file.frm, I guess innodb table needs some other stuff to run on but not sure what. </p>
  
  <p>How can I fix this problem? And I probably need to do more tasks of this kind, what's the correct procedure to drop myism table and recreate them as innodb ones? </p>
  
  <p>Thanks.</p>