How can I migrate from Jira 7.0.0 to the latest version without losing my data?

[JConstantine]

After the migration is complete I need to transfer my data from the embedded H2 database to MySQL database. How can I do this? Is 5.7 the last supported version of MySQL?

[Nic Brough -Adaptavist- · Accepted solution]

Export it to XML, build your new Jira system (on exactly the same version of Jira) connected to a supported version of MySQL, but empty, then import the xml.  Then you can upgrade that to the latest version.

See https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html for changing the database

[JConstantine]

If I create a new JIRA instance connected to MySQL supported by JIRA 7.0.0, import an XML backup file then I will not only need to update JIRA, but also MySQL, right?