nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Looking for some expert help on an internal database migration to MySQL database.

ddimick

Apparently I setup the trial database when doing my confluence server installation, even though I have a confluence DB on the server that I thought I had pointed the installation to. I need some help in figuring out how to do the database migration from the internal h2db to the MySQL. I know that there are a few general guides on Confluence and how to do this, but I am very new to this and would like some expert help.

Accepted answers

Nic Brough -Adaptavist-

At a very high level:

Export your data to XML using the Confluence backup option (on the server, it's in <confluence-data/exports>)
Stop Confluence
Repoint Confluence to an empty MySQL database
Restart it, and visit it in a browser
Run through the setup, until it asks if you have some XML to import
Feed it your XML backup file and wait a while

(Note - you might not get asked about import - that's ok, just follow it until you have an empty Confluence, then go to the backup tools and use "import from xml")

All comments

Nic Brough -Adaptavist-

At a very high level:

Export your data to XML using the Confluence backup option (on the server, it's in <confluence-data/exports>)
Stop Confluence
Repoint Confluence to an empty MySQL database
Restart it, and visit it in a browser
Run through the setup, until it asks if you have some XML to import
Feed it your XML backup file and wait a while

(Note - you might not get asked about import - that's ok, just follow it until you have an empty Confluence, then go to the backup tools and use "import from xml")

ddimick

Okay, that sounds easy enough except the Repoint Confluence to an empty MySQL database. Where is the file that I need to modify to point it to the other server?

Nic Brough -Adaptavist-

I was doing a high level thing because there's a lot more detail and I do not know where people might get stuck at. It is quicker to type a few lines and fill in the blanks when you ask, than replicate all the Atlassian docs with detailed annotations on where.

For the database config, head to <confluence-data> again, and in that directory, you should find a plain text file called confluence.cfg.xml - edit it and find a whole load of crud you don't care about (yet), and look for each property that starts with "hibernate.connection" - url, driver, username and password will be there

ddimick

Okay thanks, so there is not a "url" line in there or anything that looks close, I am assuming at this point that is because I used the internal DB purely by accident. I think I have another server that this is installed on as my test environment. I will look at that config and see if it is in there and add the lines that are different from there.

All in all I think this will get me what I need.

Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server