From owner-freebsd-questions@FreeBSD.ORG Mon Mar 27 12:51:30 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 62B6F16A422 for ; Mon, 27 Mar 2006 12:51:30 +0000 (UTC) (envelope-from mailing-lists@msdi.ca) Received: from mail02.msdihosting.net (9.67-18-64.networks.msdihosting.net [64.18.67.9]) by mx1.FreeBSD.org (Postfix) with ESMTP id EA85A43D4C for ; Mon, 27 Mar 2006 12:51:29 +0000 (GMT) (envelope-from mailing-lists@msdi.ca) Received: from ian.msdi.ca ([70.83.205.150]) by mail02.msdihosting.net ((iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep 8 2003))) with SMTP id CLI20599; Mon, 27 Mar 2006 07:53:28 -0500 Message-Id: <7.0.0.16.2.20060327075011.04f57890@msdi.ca> X-Mailer: QUALCOMM Windows Eudora Version 7.0.0.16 Date: Mon, 27 Mar 2006 07:51:23 -0500 To: Glenn Dawson ,freebsd-questions@freebsd.org From: Ian Lord 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> Mime-Version: 1.0 X-DEBUG: 1 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Re: mysql-server50 lacks supports for innodb ??? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Mar 2006 12:51:30 -0000 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