migrating h2 to mysql

[Alessandro Gismondi]

Hi, I've installed and configured Jiira Service Desk try version for one month, then we purchase it.

Now we must migrate db from H2 to Mysql.

How can we made migration? Wich version of mysql we must install?

And how to migrate all configurations we made in past month?

Thanks in advance.

[Nic Brough -Adaptavist- · Accepted solution]

A lot of us do this.  Start at https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html for how to switch databases.

Your configurations will remain the same, most (possibly all) of them are held in the database which won't change, and the ones you may have done on the server side won't change when you move databases - all you are really doing is saying "hey, use that database there instead of the old one" - nothing else has to change other than that pointer.

For versions, look for the "supported platforms" for the version of Jira you have.