NoswaD Latest Blogs

Mysql - don't forget if you set innodb_force_recovery

Andy — Mon, 26 May 2008 12:35:02 +0100

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

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.

Bad News

Andy — Mon, 28 Apr 2008 11:38:55 +0100

I'm regretting announcing our happy news at the moment, as sadly Diana died before she was born.

Somewhat ironically so did this blog while we took some time off to reflect.... back now of course.

Bake yourself a complete admin backend - in one call

Andy — Mon, 24 Mar 2008 21:46:49 +0100

Happy Christmas leveille!

How would you like to be able to generate your entire admin backend in one call? Not interesting enough? How about with built in index filters and by writing practically no code? Well... keep reading then :).

Ego v Benefit

Andy — Tue, 19 Feb 2008 13:35:35 +0100

As many will now know the Cookbook for CakePHP is now live. Coupled with the Bakery that should mean that documentation, and finding info regarding cake, just got a whole lot easier. These two applications now mean that the scope for this blog is reduced to things that I don't deem either book worthy (not documenting how to use something) or bakery worthy (useful info that is worth sharing) and that leaves... what?

So I'm now left asking myself what do do with this blog - should I be selfish and keep posting useful stuff to it (ego) or should I put info into the book and the bakery where more people will find it (benefit). I think benefit wins, but we'll see what the future brings :).

Visualize your models

Andy — Sat, 26 Jan 2008 11:00:39 +0100

Happy new year!

Way back in December I found an awesome article by Cakeexplorer on a script to build an image of your db schema. I had been meaning to write such a script for some time, it was great to have it already ticked off the to-do list.