MySQL Forums
Forum List  »  InnoDB

Existing MySQL without InnoDB Support
Posted by: Larry Fabian
Date: March 30, 2005 03:45PM

I have version 4.0.21 setup and runinng on a SuSE 9.2 workstation. This was the typical install from the installation CD with no specific options selected or deselected. Turns out I cannot enable InnoDB support as I get various error messages depending upon the actions I take. For instance, if I edit the my.cnf in /etc (it's the only one on the machine), I get an "unknown variable" error when starting mysqld complaining about "innodb_data_home_dir=/var/lib/mysql". If I comment this out (along with the other variables in the relevant section of my.cnf), "mysql> show variables" says I do not have innodb.

I suspect it's because the software was configured as "/configure --without-innodb", but I don't know that for a fact. I've tried about every combination of starting/stopping the server, creating/moving/deleting the home_dir and other directories, so short of reconfiguring and recompiling, is there a method to enable InnoDB support in an existing MySQL that has MyISAM as the default table type?

The application I'm trying to install requires InnoDB support which is why I'm going through this. One caveat if it's important, I have existing databases that do not need to be "changed" to InnoDB type.


Options: ReplyQuote

Written By
Existing MySQL without InnoDB Support
March 30, 2005 03:45PM
March 31, 2005 06:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.