Mysql - don't forget if you set innodb_force_recovery

26 May 2008

By Andy, filed under SQL

Today I got the following error message:

andy@andy-desktop:~/www$ mysql -uroot < db_dump.sql 
ERROR 1030 (HY000) at line 2564: Got error -1 from storage engine

1. andy@andy-desktop:~/www$ mysql -uroot < db_dump.sql
2. ERROR 1030 (HY000) at line 2564: Got error -1 from storage engine
3.  

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.