Excellent, thanks much, that solved the problem: mysql> SHOW VARIABLES LIKE 'have\_%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_bdb | NO | | have_gemini | NO | | have_innodb | NO | | have_isam | YES | | have_raid | NO | | have_ssl | NO | +---------------+-------+ 6 rows in set (0.00 sec)
mysql> Looks to pretty clear like it ain't there. Carl On Sun, 7 Apr 2002, Paul DuBois wrote: > At 20:23 -0400 4/7/02, Carl Schmidt wrote: > >I don't believe my web host has either InnoDB or BDB installed on their > >system so I ran some tests here: > > > >mysql> alter table Development_EventType TYPE=INNODB; > >Query OK, 3 rows affected (0.00 sec) > >Records: 3 Duplicates: 0 Warnings: 0 > > > > > >That's the result I get, but when I do a table dump, the type is still > >showing MyISAM. > > > >1. Is my syntax correct on this? > > Yes, but MySQL won't complain if you alter a table to a type that isn't > available. > > >2. Is there a way to list table types installed in a system? I do have > >php installed , there, if that helps. > > SHOW VARIABLES LIKE 'have\_%' will show many of them. MyISAM doesn't > show up in the list; it's always available, from MySQL 3.23 on. > > >Carl > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php