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.