From owner-freebsd-questions@FreeBSD.ORG Mon Mar 27 23:57:37 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 E875416A420 for ; Mon, 27 Mar 2006 23:57:37 +0000 (UTC) (envelope-from glenn@antimatter.net) Received: from cobalt.antimatter.net (cobalt.antimatter.net [69.55.224.239]) by mx1.FreeBSD.org (Postfix) with ESMTP id A1BEF43D45 for ; Mon, 27 Mar 2006 23:57:37 +0000 (GMT) (envelope-from glenn@antimatter.net) Received: from foo.antimatter.net (cpe-66-74-219-72.san.res.rr.com [66.74.219.72]) (authenticated bits=0) by cobalt.antimatter.net (8.13.4/8.13.4) with ESMTP id k2RNvaK3006288 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 27 Mar 2006 15:57:37 -0800 X-MailKey: purple frogs are falling from the sky Message-Id: <7.0.1.0.2.20060327155152.065a1f60@antimatter.net> X-Mailer: QUALCOMM Windows Eudora Version 7.0.1.0 Date: Mon, 27 Mar 2006 15:55:40 -0800 To: Ian Lord , freebsd-questions@freebsd.org From: Glenn Dawson 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> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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 23:57:38 -0000 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"