innodb being skipped without skip-innodb

Hello NG-
I'm using mysql 5.0.22 as packaged (and updated) with Ubuntu Dapper.
I would like to use Innodb, but "show innodb status" says "ERROR 1235
(42000): Cannot call SHOW INNODB STATUS because skip-innodb is
defined". However, there is no skip-innodb in anywhere in
/etc/mysql/my.cnf. I found a file called /etc/mysql/debian.cnf which
appears to be used as a defaults file for behind-the-scenese stuff. It
doesn't mention skip-innodb. I've checked /etc/init.d/mysql and it has
no reference to skip-innodb.
I've googled the issue, and can't find anything. Am I missing
something?

Jake
jacobmarble [ Do, 28 Dezember 2006 22:03 ] [ ID #1579332 ]

Re: innodb being skipped without skip-innodb

http://dev.mysql.com/doc/refman/5.0/en/innodb-init.html

On Dec 28, 2:03 pm, "Jacob Marble" <jacobmar... [at] gmail.com> wrote:
> Hello NG-
> I'm using mysql 5.0.22 as packaged (and updated) with Ubuntu Dapper.
> I would like to use Innodb, but "show innodb status" says "ERROR 1235
> (42000): Cannot call SHOW INNODB STATUS because skip-innodb is
> defined". However, there is no skip-innodb in anywhere in
> /etc/mysql/my.cnf. I found a file called /etc/mysql/debian.cnf which
> appears to be used as a defaults file for behind-the-scenese stuff. It
> doesn't mention skip-innodb. I've checked /etc/init.d/mysql and it has
> no reference to skip-innodb.
> I've googled the issue, and can't find anything. Am I missing
> something?
>
> Jake
jacobmarble [ Do, 28 Dezember 2006 22:57 ] [ ID #1579333 ]
Datenbanken » mailing.database.mysql » innodb being skipped without skip-innodb

Vorheriges Thema: request help for subquery
Nächstes Thema: MySQL performance question on SELECT and JOIN. experts only