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 votes

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
Community showcase
Published Feb 26, 2019 in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

600 views 0 7
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