Copying jira database from crashed

I was using JIRA 4.2 standalone on my PC.

Unfortunately it crashed, but I could recover my data.

How can I now copy the old database (jira home directory) into a new 4.2 instance?

I was told to just copy the jira home directory after installing but it doens't seem to work. :s

Any more ideas?

2 answers

1 accepted

Accepted Answer
1 vote

Hello Sir,

Nic has right but, in my opinion, you can also perform this check. If your JIRA had a backup automatic service enabled, you will find the last backup available into your <JIRA-HOME>/export folder.

Using it, you can recovery all db data. So, install a new jira and perform a restore using that file.

Hope this helps,

Fabio

Worked! :D

Tried it before, dunno why it didn't worked...

Whatever, I got my data back!

TY! :D

1 vote

Possibly.

It depends mainly on what the database was. If you were using a proper database, then you should be able to install a new Jira 4.2, copy the home directory, and point it at the database.

If, however, you were using the built-in HSQL, then the good news is "yes, you can simply copy the home directory". The bad part is that HSQL is prone to catastrophic failure, and has no resilience in it - if the database file becomes damaged, it can easily lose everything.

So... what database were you using?

The second story, a local default database.

Copying nor jira gave me errors, so thought it would be ok

Not with HSQL - that can fail spectacularly.

Anyway, if the plain copy has not worked because your HSQL database is trashed, your only real hope is what Fabio said about backups.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

47 views 0 2
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