I was trying to decrypt my Linux server hard drive but ran into some problems. Long story short, I now want to reinstall Ubuntu on my machine and restore my previous JIRA database from a hard drive backup on an external hard drive. In other words, I cannot boot from my hard drive backup but have all the data and want to restore my JIRA database from where it sat on the computer before I messed it up. I do not have a JIRA backup, only a hard drive backup. Can this be done? Can I install JIRA and run it using the database on this hard drive so I can migrate it back to the machine? What steps do I need to take? What problems might I run into? Thanks for any and all help!
Since I had no database dump and simply a hard drive backup to work from, I had to patch together several techniques to get back my JIRA installation. I don't know if I will be able to recall all of the specifics but I can try:
I may not have been as complete with every step so don't be surprised if you run into errors. With good enough Googling, you should be able to get past every step. Keep in mind this was on Ubuntu 14.0.4 and JIRA v6.4.2#64017 (build number is important, I now know). It's entirely possible this will work on other distros but the steps will be different, at least as far as the locations of things are. I cannot attest as to whether this will work with other databases though. If anyone is as dumb as I am, hopefully this helps you out!
We do following to create new test JIRA instance:
It works well.
I see. I have never used this, but during installation of JIRA there is an ability to create JIRA from database.
See this for instractions: https://confluence.atlassian.com/jira/running-the-setup-wizard-185729463.html
Namely see "Production and testing setup" where you can select database to connect.
Also pay attention, that attachements are not stored into database. You have to copy it manually.
You need to get two things from the disk - the attachments, which Vasiliy already mentioned, which is a simple case of "copy a directory", and the database, which could be difficult.
Problem with the database is that it varies between installs. "What database were you using?" is the first question, as it determines how to recover it.
if you have a dump of the database you can bring back to life your old JIRA instance witouth much trouble. I've done it recently, having MySQL as DBMS.
The steps I followed:
Create a database. Something like
CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON jiradb.* TO 'jirauser'@'%' IDENTIFIED BY 'password';
# mysql -u root -p
mysql> drop database jiradb;
# nohup mysql -u root -p jiradb < ./your_dump.sql
You might have problems due to missing plugins and so. You'll need to examine the log, to discover and fix possible issues.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot