Date: Mon, 27 Mar 2006 07:47:49 -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.20060327073700.04f557d8@msdi.ca> In-Reply-To: <7.0.1.0.2.20060326234515.0809a9e0@antimatter.net> References: <7.0.0.16.2.20060327012042.04bfc9c8@msdi.ca> <7.0.1.0.2.20060326234515.0809a9e0@antimatter.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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 ?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?7.0.0.16.2.20060327073700.04f557d8>