Run the following query: SHOW VARIABLES LIKE 'have_%';
You should see something like this: +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_bdb | NO | | have_gemini | NO | | have_innodb | YES | | have_isam | YES | | have_raid | NO | | have_openssl | NO | +---------------+-------+ 6 rows in set (0.00 sec) It will tell you if BDB and/or InnoDB is active. It might say disabled, if so you will need to enable in my.cnf -----Original Message----- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 12:26 PM To: Weaver, Walt; [EMAIL PROTECTED] Subject: Re: Forcing Table Types I am using the RPM's, but it didn't give an error so I'm assuming it is properly configured. The MySQL version is: [ken@ken ken]$ mysql --version mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686) Sorry -- I should have included that. I'm assuming there's something wrong with my syntax as I can't create Berkley tables either. Frankly I don't care what table type I use, I just want transactions -- and if I can get them, foreign keys w/ cascade deletes, etc... On Friday 28 December 2001 01:25 pm, Weaver, Walt wrote: > Ken, > > When you configured/compiled MySQL, did you use the --with-innodb option? > What version of MySQL are you running? > > FWIW, I wasn't real impressed with the Berkeley tables, but the InnoDB > tables work very well. > > --Walt Weaver > Bozeman, Montana > > -----Original Message----- > From: Ken Kinder [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 28, 2001 1:09 PM > To: [EMAIL PROTECTED] > Subject: Forcing Table Types > > > This is getting really annoying. No matter what type of table I create, it > ends up being MyISAM. I _must_ have at least transactions and foreign key > support would be nice. Also, does anyone know how I can have transactions > on > > create table statements? > > Here the interaction with MySQL that is driving me crazy. It's kind of > messy, > but you'll notice my foo table ends up being MyISAM. The same thing happens > for Berkley tables. > > mysql> create table foo ( > -> foo_id int auto_increment not null, > -> whatever text, > -> primary key(foo_id) > -> ) type=InnoDB; > Query OK, 0 rows affected (0.00 sec) > > mysql> show create table foo; > +-------+--------------------------------------------------------------- --- >- ----------------------------------------------------------+ > > | Table | Create Table > > +-------+--------------------------------------------------------------- --- >- ----------------------------------------------------------+ > > | foo | CREATE TABLE `foo` ( > > `foo_id` int(11) NOT NULL auto_increment, > `whatever` text, > PRIMARY KEY (`foo_id`) > ) TYPE=MyISAM | > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
