-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tuesday 02 December 2003 11:23, Chris Carter wrote: > Hi, > > This may seem a little off-topic but I can't seem to get my hands round > this. > > I emerged mysql 4.0.14 with USE=innodb in my make.conf; which built just > fine. > > I created a database and added some tables using type=innodb and started > working with them just fine. Yesterday morning I noticed the tables were > recognised as MyISAM. I tried to change them (eg: alter table aliases > type=innodb;) and my alter queries run perfectly (no errors) however the > tables still are 'MyISAM'.
Mildly annoying that isn't it? > I've even re-emerged mysql (and seen the innodb stuff get included) but > to no avail. The documentation available on the mysql website does not > express any special requirements other than 4.x version. What am I > missing? I suspect you need to uncomment the 'skip innodb' line in /etc/mysql/my.cnf. Then you may need to add the variables to configure innodb, the data file size/path etc. - -- Mike Williams -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQE/zQPWInuLMrk7bIwRAoCsAJ4sFO8E376TH7PQ1wZWf4YBAj8ZzQCePNrP NPLsj9jWucpQCkDFbZKHjpE= =rLX5 -----END PGP SIGNATURE----- -- [EMAIL PROTECTED] mailing list
