The Hard-drive of the machine I was evaluating Jira with died shortly after I acquired a starter license. I setup my new production instance of Jira on a server with Postgresql DB. But now I want to transfer just a single project from the H2 DB evaluation install (I have managed to recover the files and can access the H2 database) without messing up my user accounts and everything else now on my Postgresql db. So I don't want to migrate wholesale, just a project. Can I do this?
You'll need to restore the original Jira instance in order to get your project back. It won't be possible to recover from the H2 DB directly.
For this, you have two options:
Please take the time to review this and let me know if you want any more details on either option.
Thanks Shannon, option 1 was simple enough .. but after pointing dbconfig.xml to my old database and restarting jira I can see my project, but I do not see any of the issues. I only copied the /var/atlassian/application-data/jira/database directory, I thought that would be enough for the entire contents of the old instances database.
Can you think of any reason I would see the project, but not the issues?
I would first try reindexing Jira entirely and see if that helps your issue.
If not, it could be that dbconfig.xml isn't pointing to the right place. Can you check that it's now pointing to where you placed the H2 file exactly?
If it is, then I would recommend checking the Jira server logs, as Jira might be having an other issue.
Hi - your original response is what got me down the right path. I worked the indexing out for myself but hit a stumbling block with not being able to export the database because I wasn't logged in as sysadmin for which I needed to some database gymnastics - actually just copied the hashed password for a user I could login as into the sysadmin user entry.
Hi Everyone! My name is Mina and I am on Atlassian’s Ecosystems Marketing team. Our team is focused on our technology partnerships and marketplace apps. One of Atlassian’s partners is Slack, who ...
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