On Thu, 10 May 2001, Jeremy Zawodny wrote:
> On Thu, May 10, 2001 at 11:29:06AM -0700, Eric J. Schwertfeger wrote:
> >
> > I'm trying to get INNOBASE tables working with MySQL on FreeBSD and
> > I've run into something unusual.
> >
> > Basically, when I create a table with "type = innobase" then do a
> > stat on the table, it returns a table type of MyISAM. I've verified
> > that this is what the table really is by looking for the appropriate
> > files in the data directory.
> >
> > BDB tables, however, work fine.
>
> What does "SHOW VARIABLES" say? There should be a have_innobase
> record.
Thank you, that is exactly the first step I was looking for! (confirmation
one way or the other that I had innobase support compiled in).
have_bdb YES
have_gemini NO
have_innodb NO
The first two are as expected, the third isn't. However, this is with a
mysqld that was configured with --with-innobase. So why is
have_innodb=NO?
---------------------------------------------------------------------
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
