Mysql - don't forget if you set innodb_force_recovery

26 May, 2008

Show comments

Today I got the following error message:

[email protected]:~/www$ mysql -uroot < db_dump.sql 
ERROR 1030 (HY000) at line 2564: Got error -1 from storage engine

I couldn't figure out what could possibly be the cause - the file was valid and worked on another machine.

So that I don't forget the next time I come across this error, and that something exists on the web with all relevant keywords for the next poor schmoo: Don't forget that if you temporarily set innodb_force_recovery in your my.cnf file to remove it before trying to act on on innodb tables.