Date: Mon, 27 Mar 2006 15:55:40 -0800 From: Glenn Dawson <glenn@antimatter.net> To: Ian Lord <mailing-lists@msdi.ca>, freebsd-questions@freebsd.org Subject: Re: mysql-server50 lacks supports for innodb ??? Message-ID: <7.0.1.0.2.20060327155152.065a1f60@antimatter.net> In-Reply-To: <7.0.0.16.2.20060327075011.04f57890@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> <7.0.0.16.2.20060327075011.04f57890@msdi.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
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@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-questions >To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?7.0.1.0.2.20060327155152.065a1f60>