I have a completely functional Confluence Server system with quite a bit of data and attachments. I would like Confluence to point to a local MySQL database (already installed and configured) rather than the current HSQL database. The articles that I've found talk about setting this during initial installation. How can I point Confluence to MySQL now that I've been up and running a year or so?
You can edit the confluence.cfg.xml file in the home directory to swap over, but a lot of the stuff in it is quite obscure and it would be a very good idea to work from an example copy.
An easy cheat would be to run an install of a new system (on the same version) and configure it for your new MySQL database, let it get to the point where you can log in, then stop it and then you'll be able to do a direct comparison on a MySQL vs H2 config files and pretty much copy and paste all the settings into the existing ones.
This is really beating me up. I found a good xml from a previous Confluence/MySQL installation and tried numerous permutations on the XML without success.
Below are the differences I detected in "/var/atlassian/application-data/confluence/confluence.cfg.xml". Other than the id, licenses and keys of course. It just won't start. I go back to the original XML and it's fine (on H2).
<property name="hibernate.c3p0.preferredTestQuery">select 1</property>
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events