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

This widget could not be displayed.

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 yesterday in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

49 views 2 2
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