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...

read more1 comment

  • How to delete an MPTT Node

    03 Sep 2006

    By Andy, filed under CakePHP, Tools, ACL, Tips, MPTT, Hacks, SQL

    If you use MPTT tables anywhere (The cake acl system uses it) you may have found that when you delete an entry, the lft and rght fields for the neighouring nodes don't get updated. This may have rather dire concequences ;)

    There is an open ticket for how to delete from the cake acl tables, but as it is potentially quite generic, I thought I'd include the (potential)...

    read more1 comment

«  »