From owner-freebsd-questions@FreeBSD.ORG  Thu Nov 30 12:47:39 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 [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id B9DB316A512
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Nov 2006 12:47:39 +0000 (UTC)
	(envelope-from lenny@edpausa.com)
Received: from skywalker.edpausa.com (mail.edpausa.com [67.88.41.162])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 5A8C943CA3
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Nov 2006 12:47:22 +0000 (GMT)
	(envelope-from lenny@edpausa.com)
Received: from localhost (localhost.edpausa.com [127.0.0.1])
	by skywalker.edpausa.com (Postfix) with ESMTP id 848AFC97E9
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Nov 2006 07:47:25 -0500 (EST)
X-Virus-Scanned: amavisd-new at edpausa.com
Received: from skywalker.edpausa.com ([127.0.0.1])
	by localhost (skywalker.edpausa.com [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 0pcpvlhWs02K for <freebsd-questions@freebsd.org>;
	Thu, 30 Nov 2006 07:47:15 -0500 (EST)
Received: from mail.edpausa.com (localhost.edpausa.com [127.0.0.1])
	by skywalker.edpausa.com (Postfix) with ESMTP id 30A06C9669
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Nov 2006 07:45:57 -0500 (EST)
Received: from 216.254.116.226 (SquirrelMail authenticated user lenny)
	by mail.edpausa.com with HTTP; Thu, 30 Nov 2006 07:45:57 -0500 (EST)
Message-ID: <54480.216.254.116.226.1164890757.squirrel@mail.edpausa.com>
Date: Thu, 30 Nov 2006 07:45:57 -0500 (EST)
From: lenny@edpausa.com
To: freebsd-questions@freebsd.org
User-Agent: SquirrelMail/1.4.8
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
Subject: no innodb support in mysql 5.0 port
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: Thu, 30 Nov 2006 12:47:39 -0000

compiled with default options ( not setting WITHOUT_INNODB ), but when I
start the server, I can't create or convert any tables to InnoDB format.
I tried various my.cf files ( including my-innodb-heavy-4G.cnf and without
any cnf files,

show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is
defined


show engines;

| InnoDB     | DISABLED | Supports transactions, row-level locking, and
foreign keys



How do I get InnoDB working ? please help !!