mysql-server50 lacks supports for innodb ???

[Glenn Dawson]

At 04:51 AM 3/27/2006, Ian Lord wrote:
>At 07:47 2006-03-27, Ian Lord wrote:
>>At 02:47 2006-03-27, Glenn Dawson wrote:
>>>At 10:22 PM 3/26/2006, Ian Lord wrote:
>>>>Hi,
>>>>
>>>>I just installed mysql-server50 port for the ports databases directory...
>>>>
>>>>I compiled it using defaults
>>>>
>>>>make
>>>>make install
>>>>
>>>>and InnoDB is not available...
>>>>
>>>>What's wrong with the port ???
>>>
>>>I have mysql50-server built and installed with the defaults, and 
>>>it has support for innodb.
>>>
>>>What did you do to determine that your install does not have support?
>>
>>I really don't know... It's a clean machine, just reinstalled 
>>freebsd and then I did a make and make install
>>in the ports /usr/ports/database/mysql50-server/
>>
>>Obviously, I didn't use the without_innodb flag
>>
>>When I try to create a innodb table by using
>>create table foo (bar mediumint(8)) ENGINE=InnoDB;
>>
>>If I do a
>>show create table foo;
>>+-------+----------------------------------------------------------------------------------------------+
>>| Table | Create Table |
>>+-------+----------------------------------------------------------------------------------------------+
>>| foo  | CREATE TABLE `foo` (
>>   `bar` mediumint(8) default NULL
>>) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
>>+-------+----------------------------------------------------------------------------------------------+
>>
>>The innodb is not there it defaults back to myisam
>>
>>Anyone knows what could be wrong ?
>
>I just did a
>mysql> show engine innodb status;
>ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because 
>skip-innodb is defined
>
>So I see the server is really skipping innodb... just strange that 
>the default install does this !
>I'll try to figure out what config file I need to modify so this 
>doesnt happen...

What does output from:

show engine innodb status;

show?

-Glenn

>Thanks for your help
>
>_______________________________________________
>freebsd-questions at freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"