Archive for December 31, 2007

Configuring Mutt for IMAP support

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.

Unknown table engine ‘InnoDB’

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