my life

day to day

Archive for December, 2007

Configuring Mutt for IMAP support

Monday, December 31st, 2007

Configuring Mutt with IMAP is as easy as editing your .muttrc and adding the following lines.

set spoolfile=imap://username:password@host/INBOX set folder=imap://username:password@host/INBOX

You can then change folders inside of Mutt by pressing ‘c’ and then ‘?’ to get a folder list.

add to del.icio.us    add to technorati favs   email this

Unknown table engine ‘InnoDB’

Sunday, December 23rd, 2007

I was getting the error “ERROR 1286 (42000): Unknown table engine ‘InnoDB’” when trying to create/alter tables with the InnoDB engine. You can check for this warning by issuing the create or alter statements and then running

show warnings;
in the same mysql client session.

Check if you have InnoDB support enabled:

mysql> show variables like ‘have_innodb’; +—————+———-+ | Variable_name | Value    | +—————+———-+ | have_innodb   | DISABLED | +—————+———-+

The problem is that InnoDB is not enabled by default in Debian distributions of my.cnf.  To enable it, simply comment the following lines under the [mysqld] section.

#skip-innodb

add to del.icio.us    add to technorati favs   email this