> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]