From: Martijn Tonies
Date: October 31 2004 11:33am
Subject: Re: Converting table type
List-Archive: http://lists.mysql.com/mysql/175043
Message-Id: <003601c4bf3d$83d76c20$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> At 11:06 -0500 10/30/04, Michael Satterwhite wrote:
> >On Saturday 30 October 2004 10:58 am, Paul DuBois wrote:
> >>
> >>  What output does the following statement produce?
> >>
> >>  SHOW VARIABLES LIKE 'have_innodb';
> >>
> >>  If YES, the ALTER TABLE statement should have worked.
> >>  If NO, your server doesn't have InnoDB support built in.
> >>  If DISABLED, your server supports InnoDB but it was disable at
> >>  startup time with --skip-innodb.
> >
> >That was it. Thanks. I didn't think of Debian disabling the INNODB
function.
>
> Rude of them. :-)

Add to that: what about raising an error/warning message
when something like that fails??

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com