Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Restoring access to user database to export a backup for cloud migration

Our VM crashed and I am only able to recover the data from an image backup that was taken. I can't remap the databases for Jira, Confluence or any others. I tried to install a new instance of the program in order to restore or modify a config to point at the old databases. I have the entire contents of the application folders and the SQL databases from the old system but I don't see where to reattach or point to the databases in the new instance.

1 answer

0 votes
Andy Heinzer Atlassian Team Jul 02, 2021

Hi William,

I understand that you are trying to restore a Jira server instance from a backup, but appear to be unable to connect to the old database.  Jira server determines what database to connect to by looking into the $JIRAHOME/dbconfig.xml file.  There are a few different way for you to be able to update that file. 

My preferred method is to use the Jira config tool to manage this.  This utility helps update that file and other configuration files needed to setup Jira.

There is also a concern about version differences in Jira.  What version was the old version of Jira?  And what version did you install after the crash?  I only ask this because sometimes the version differences have been known to be too great to successfully complete an upgrade in this manner.

Another concern is to try to understand what database type and version of the database you are using here.  This is two fold: for one there is a concern about database compatibility between versions, and secondly some databases such as MySQL, Jira cannot connect to until you manually download and install the jdbc .jar file.  Due to licensing restrictions, Atlassian is not able to bundle that file with the installer. 

As a general guide for setting up Jira to connect to a database, I recommend Connecting Jira applications to a database.  It has lots of information and links to specific database type guides that are helpful here.

Try those resources and let me know if you have any questions or concerns about this.

Andy

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

861 views 2 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you