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,jira.plugin.state-.com.spartez.scrumprint.scrumplugin][type,5][entityName,jira.properties] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Column 'ID' cannot be null))

Thoughts?

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
Joe 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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,110 views 13 19
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot