InnoDB DISABLED

InnoDB DISABLED

Posted by: fortuna
Posted on: 2007-02-28 02:04:00

Hi all,

I'm trying to install activeCollab, but upon installation get the following error:

"InnoDB storage engine is not supported"

I've check in phpMyAdmin and it tells me that InnoDB is disabled for my MySql Server. Confirming this, have_innodb = DISABLED, and trying to create a table I don't get the InnoDB option.

So my question is, how can I enable InnoDB?

Any help is greatly appreciated.

regards,
ben


Re: InnoDB DISABLED

Posted by: anonymous2
Posted on: 2007-02-28 02:13:00

http://www.google.com/search?hl=en&q=site:wiki.dreamhost.com+innodb

Option in Goodies when creating new database?

Re: InnoDB DISABLED

Posted by: anonymous2
Posted on: 2007-02-28 02:21:00

Sorry, option when creating tables?

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

CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

Re: InnoDB DISABLED

Posted by: fortuna
Posted on: 2007-02-28 02:44:00

Nah that's the problem. I don't get that option because InnoDB is disabled on the entire server (none of my DBs have the option). The only options in the pick-list are:

MyISAM
MEMORY
ARCHIVE
MRG_MYISAM

Selecting InnoDB from the Storage Engines page says:

"InnoDB has been disabled for this MySQL server."

Thanks for your help.

ben


Re: InnoDB DISABLED

Posted by: BUGabundo
Posted on: 2007-02-28 03:05:00

contact support and lets us know

Re: InnoDB DISABLED

Posted by: fortuna
Posted on: 2007-02-28 17:30:00

Hi Guys,

Just got a reply from support:

"I'm sorry about that, there were a few straggler MySQL servers left that
didn't have InnoDB enabled. I just had the database admin turn it on
globally, so you're good to go"

Thanks for your interest.

regards,
ben


Tags: greatly appreciatedphpmyadminstorage enginemysql server