Date: Mon, 27 Mar 2006 07:51:23 -0500 From: Ian Lord <mailing-lists@msdi.ca> To: Glenn Dawson <glenn@antimatter.net>,freebsd-questions@freebsd.org Subject: Re: mysql-server50 lacks supports for innodb ??? Message-ID: <7.0.0.16.2.20060327075011.04f57890@msdi.ca> In-Reply-To: <7.0.0.16.2.20060327073700.04f557d8@msdi.ca> References: <7.0.0.16.2.20060327012042.04bfc9c8@msdi.ca> <7.0.1.0.2.20060326234515.0809a9e0@antimatter.net> <7.0.0.16.2.20060327073700.04f557d8@msdi.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
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... Thanks for your help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?7.0.0.16.2.20060327075011.04f57890>