Existing MySQL without InnoDB Support
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.
Thanks
Subject
Views
Written By
Posted
Existing MySQL without InnoDB Support
6373
March 30, 2005 03:45PM
2551
March 31, 2005 06:23AM
2473
March 31, 2005 12:24PM
2621
April 30, 2005 12:09AM
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.