At 04:51 AM 3/27/2006, Ian Lord wrote:
At 07:47 2006-03-27, Ian Lord wrote:
At 02:47 2006-03-27, Glenn Dawson wrote:
At 10:22 PM 3/26/2006, Ian Lord wrote:
Hi,

I just installed mysql-server50 port for the ports databases directory...

I compiled it using defaults

make
make install

and InnoDB is not available...

What's wrong with the port ???

I have mysql50-server built and installed with the defaults, and it has support for innodb.

What did you do to determine that your install does not have support?

I really don't know... It's a clean machine, just reinstalled freebsd and then I did a make and make install
in the ports /usr/ports/database/mysql50-server/

Obviously, I didn't use the without_innodb flag

When I try to create a innodb table by using
create table foo (bar mediumint(8)) ENGINE=InnoDB;

If I do a
show create table foo;
+-------+----------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------------+
| foo  | CREATE TABLE `foo` (
  `bar` mediumint(8) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-------+----------------------------------------------------------------------------------------------+

The innodb is not there it defaults back to myisam

Anyone knows what could be wrong ?

I just did a
mysql> show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined

So I see the server is really skipping innodb... just strange that the default install does this ! I'll try to figure out what config file I need to modify so this doesnt happen...

What does output from:

show engine innodb status;

show?

-Glenn

Thanks for your help

_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to