How do I setup MySQL tables with InnoDB?

Henrik Winther

I have been trying to install Confluence 3.5.9 on Kubunu 10.04, the war variant with a Tomcat 6.0.26. Java is 1.6.0_06_b02.

When I am going through the wizard, it suggest a URL to start the MySQL session that contains this:

jdbc:mysql://localhost/confluence?autoReconnect=true&sessionVariables=storage_engine%3DInnoDB

MySQL does not much care for the %3D bit, and the database setup crashes.

I have tried setting up MySQL with query logging, and replacing the %3D with =. Unfortunately this does not result

in InnoDB tables, MySQL just sticks to the default MYISAM. The setup does not crash though.

If I try to start confluence with MyISAM tables it immediately bombs out with an exception.

Does anybody have a clue about this?

Kind regards

Henrik

Jens Gombert

Confluence need InnoDB since 3.5 or somethink like this. See the release notes.

For your MySQL Server have a look at 2.4 in this guide:

http://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL

If you have a DB you want to use update the tables to InnoDB.

Not sure if this is the right answer...