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

[Jose Cardenas]

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?

[Nic Brough -Adaptavist-]

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.

[somethingblue]

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.

• Windows: Open a command prompt and run config.bat in the bin sub-directory of the JIRA installation directory.
• Linux/Unix: Open a console and execute config.sh in the bin sub-directory of the JIRA installation directory.
   This may fail with the error as described in our Unable to Start JIRA applications Config Tool due to No X11 DISPLAY variable was set error KB article. Please refer to it for the workaround.

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