Our Jira app server crashed we have a JiraDB SQL Backup, can we restore this to a new Jira system?

We previously had Jira installed on an app server while the JiraDB is hosted on an Sql server. 

We have installed Jira on new app server and are trying to connect to the original database, what are the steps required?

2 answers

1 vote

Probably the safest and easiest method:

Create a new empty schema on your database server (this is temporary)

Create the new application server and point it at the empty database to get it fully configured

Once you have this able to log in, you know you have a working Jira system, so shut it down.

Go to the Jira home directory and edit dbconfig.xml.  You should find a row in it pointing to the new database.  Change it to the old one

Restart Jira, log in as an admin, and re-index (in full, not the background one).  Throw away the new database while you wait.

0 vote

Hi Jose,

You can use the JIRA application configuration tool to connect to your other database:

Starting the JIRA configuration tool

The JAVA_HOME environment variable must be set to use the JIRA configuration tool. If it has not been set already, follow the instructions in Installing Java to set it.



The JIRA configuration tool can be run with a graphical user interface or via a command-line interface using the -c or --console argument. The following sections show the graphical user interface, but the functionality is the same regardless of the interface.

Hopefully that helps.



Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Schuster
Posted Mar 28, 2018 in Jira Software

Can a company’s culture make or break agile adoption?

Can a new-to-agile team survive and thrive in a non-agile culture? If so, what advice would you give to those trying to be agile in a non-agile culture? What's the key(s) to success? Share your thoug...

13,142 views 15 13
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