Migrating is not working

I installed JIRA 3 months back, now I need my JIRA on another VM than it is currently running on. I follow the instructions on how to migrate. Once new JIRA is running, all my old plugins are there, but that is ALL that got transfered. Users, Projects and other data is not there.

Please help! I am stuck and up $#%% creek without a paddle!!!!! =)

11 answers

1 accepted

0 vote
Joe Pitt Community Champion Jan 06, 2014

You need to do a backup from the old instance and import into the new one. Since you're using the built in database it will create it for you.

0 vote

Sounds like you missed the move of the actual database.

What database are you using?

Hi Chad

You just pointed the new JIRA install to a backup database dump or you generated an xml backup at the old instance and restored it at the new install?

You can run the config file at your new jira-install/bin and check the database settings to see if is pointing correctly to the new database.

Hope it helps,

Ricardo Carracedo.

Hey guys! Thank you so very much for the fast responses and genuine attempts at resolving my issue.

Unless I missed something, I was informed to make back ups of everything, but I did not get any instructions on importing anything but old JIRA home dir as the new one.

Here is what I did:

Made backups of everything

Copied old JIRA home to new server

Pointed new JIRA to use old home dir.

Copied a few parts of files from old JIRA into new JIRA (old JIRA and new JIRA are same version, btw) like instructed

started new JIRA.. and this is where I am at now.

I made a reply... but for some reason they thought it was spam. I am using the built in DB atm. Once I get everything working right again I will be migrating to MSSQL 2012

0 vote
Ok. Hsql then. You have not told us what you did to "migrate". Was it a full export and import into an empty system? Or did you simply try to move the whole database? The instructions you read probably mentioned export and import, so what did you do there?

Ya that was all in the reply I made that Atlassian is witholding atm due to it being some sort of spam (flters seem to be a bit strong, imo)

I will go over it again, but if they add my comment later just ignore it.

I made back ups of everything.

Installed New JIRA

copied old Home Dir to new server

pointed new JIRA to use the copy of old Home Dir.

edit a few files per instructions

started new JIRA

New and old JIRA are both the same version

Okay, will look into replacing the DB. Thanks guys! I will report back!

Great work guys! thanks so much for all your help. Very friendly! Nice experience for my first question on this forum! Awesome =)

Thanks for the previous help guys, but now I face a problem where everything was/is working, but not correctly.

Once I restored system and started JIRA everything worked. But when I restart the VM, JIRA service starts but JIRA does not have project data. Users are there and the project itself is there, but the acttivity and issues are not. Stop JIRA service, restore system again and then start jira using the batch file is the only to get my data to show up.

Any help would be awesome! I am not above starting my JIRA installation over from scratch on the new VM if anyone feels by forgetting to restore system the first time around is the culprit for my new issues.

Hmm. Could you try a full re-index? If you've simply restored the data, then your empty Jira won't have had a chance to build the index...

Thanks for the suggestion, but Re-Indexing did not help. I restarted and activity and issues are gone.

Ok, always worth a try.

Could you look in the database and see if there are actually any issues in it?

As you're using HSQL (which can fail catastrophically, which is what I'm starting to worry about here), you can simply open the file in a text editor (when Jira is offline, and be careful to keep it read-only) and look through it for lines that use insert into the jiraissue table. HSQL keeps its data in a couple of files in your "jira home" directory which should be called something like "database.script"

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,276 views 14 20
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