Change Jira Database URL


We are planning on changing some features to our lab and this will involve changing the IP on the MySQL server that JIRA uses.

I was wondering what we would need to do to adapt JIRA to this. The database url does not appear to be modifiable through straightforward means, and there does not appear to be any documentation on this.

I imagine this would be simpler than a migration of the database, but I am having trouble information on this particular use.

Our versions are:

JIRA Version: 7.3.0

Database Version: MySQL 5.6.35

Thank you for your time and any help you can provide.


1 answer

1 accepted

0 votes
Answer accepted

Actually, not painful at all, once you know where to look (which is, of course, less than obvious)

Stop JIRA, clone your database to the new location, then go to <JIRA home> and find the text file dbconfig.xml.  Edit the location in there in a text editor, and restart JIRA.

Thank you, sir. Thought it had to be something like this.


Something I forgot to ask, if we are also changing the IP on the JIRA host, are there any concerns with that? Will JIRA automatically pick the change up for whatever purposes it needs to be, or is there something we need to do to ensure it?

It's possible that can have an effect.  Ideally, though, you're using some form of DNS, so that <myserver.ourdomain> always resolves to the current ip address of the server.  The use of DNS means that you can mostly ignore ip changes as long as the JIRA base url does not change.


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

393 views 6 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you