Change Jira Database URL

Hello,

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

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 Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

320 views 0 12
Read article

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot