From owner-freebsd-questions@FreeBSD.ORG  Mon Mar 27 12:47:54 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 BAF5516A420
	for <freebsd-questions@freebsd.org>;
	Mon, 27 Mar 2006 12:47:54 +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 541B843D45
	for <freebsd-questions@freebsd.org>;
	Mon, 27 Mar 2006 12:47:54 +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:49:53 -0500
Message-Id: <7.0.0.16.2.20060327073700.04f557d8@msdi.ca>
X-Mailer: QUALCOMM Windows Eudora Version 7.0.0.16
Date: Mon, 27 Mar 2006 07:47:49 -0500
To: Glenn Dawson <glenn@antimatter.net>,freebsd-questions@freebsd.org
From: Ian Lord <mailing-lists@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>
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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 27 Mar 2006 12:47:54 -0000

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 ?