Restoring JIRA with only database and attachments folder

Hey there,

I am trying to restore JIRA with *only* a database dump of JIRA and the attachments folder (not the rest of the home folder).

Unfortunately, the original server has been updated to a new version of JIRA so I cant use the home directory.

Is there anyway this restore can work?

When I try it, I start JIRA, and get a page saying JIRA is locked and the following error:

Error occurred while starting Plugin Manager. while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,1][propertyKey,][type,5][entityName,] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null))


3 answers

Hi Dude,

Are you tacking backup of the database & installing fresh Jira & pointing it to the database while installing. If yes please take a note jira store the plugin information into database that where installed on the old Jira

So you need to following

1. Install the Jira

2. Shut down Jira.

3. Copy the Installed plugin & attachment from the old jira home directory to new jira directory.

4. Add the information of the database connectivity to the dbconfig.xml file &

5. Start Jira.

Once Jira start apply the integrity check on jira to check data Inconsistency & also reindex it.

Just to follow up. There is no way to do this without the old plugins directory? (the JIRA instance in question has been updated since then and all we have is the database and attachments folders).

0 votes
Joseph Pitt Community Champion Mar 10, 2014

Have you talked to the IT department to see if they have a full server backup of the application server?

Yes this is all we have.

Hi Dude,

In this case you have to do following task

1. List down the plugin installed in the older version.

2.Download it from the Marketplace.

3. Copy this to Installed plugin folder & do the above procedure

the plugin which where installed in the older version has its information into the database so when ever a Jira starts the plugin manger will check the database & does not find the specified plugin installed and point to some Error.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,712 views 17 21
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