Why JIRA server native database should be migrated?

[dotan goldberg]

What is the simplest way to do migration from JIRA native database to installed database on the same server? Which database is recommended?

[Alexis Robert · Accepted solution]

Hi @dotan goldberg , 

the best way to migrate is to do a XML backup in Jira, then remove the dbconfig.xml file in JIRA_HOME and restart Jira : you will then be able to enter the settings for your new database, and the next screen will provide a way to import your XML backup.

For the database, you can use either PostgreSQL or MySQL, all compatible databases are listed here : https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html

Let me know if this helps, 

--Alexis

[dotan goldberg]

Thank you Alexis,

I am still facing problems during the migration of JIRA server internal database to locally installed MySql server 5.7.28

Following the instructions in https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html

And using OS windows server 2016

After creating the installing MySql database and configure

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jiradbuser'@'localhost' IDENTIFIED BY 'jiradbuser';

When changing the settings in C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

[mysqld]
...
character_set_server=utf8mb4
...

 Upon MySql service restart there is a crash with error 1053

Help would be very appreciated

Best,

Dotan