Restoring JIRA with only database and attachments folder

The Dude1

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?

Satyendra Narwane

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.