Re: [cowiki-dev] [cowiki] Perplexed about INNODB

On 6/26/05, PAUL HANCHETT <[email protected]> wrote:
>  I'm trying to do a fresh install of coWiki using XAMPP.  It doesn't work,
> because the INNODB engine is "not supported".
>  
>  Any idea why not?  ("MySQL 4.1.12 running on localhost as root@localhost")
>  

More of a XAMPP question, but since we're advertising using XAMPP as
an easy way to setup innodb, this seems to be about the best (read
only) case where someone got XAMPP installed to support innodb.

First they changed these settings in my.cnf:

#skip-innodb 
default-storage-engine=innodb
default-table-type=innodb

Then, they copied my.cnf to the root and called
mysql_installservice.bat in the mysql directory.

So, it appears that you have to reinstall XAMPP to get innodb enabled,
which could have adverse side effects on any databases installed.  Not
so big a big a deal for our fresh install folks, but for someone that
is already using a xampp setup for something, not so good.  Here is
the forum thread:
http://forums.mysql.com/read.php?22,20189,26835#msg-26835

Except for customers' computers that are in for repair, I don't really
have a machine with Windows on it, so I can't test it out.

Cheers,
John