What is the simplest way to do migration from JIRA native database to installed database on the same server? Which database is recommended?
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
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
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jiradbuser'@'localhost' IDENTIFIED BY 'jiradbuser';CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
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
It looks like you're new here. Sign in or register to get started.
