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.

Cheers,

Branden

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 21, 2018 in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

1,191 views 10 18
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