It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Overwrite ADMIN user by restoring data from xml-file

Verena Alberg Feb 19, 2013


after restore an xml-file (Jira export) I can t login with the user, which was ADMIN before the import.

I know the name and the password of the ADMIN and now I need a possibility to activate it again.

The installation is a the free Jira download 5.0.6.

Unfortunately I'm not familiar with this subject, so I would be grateful for a simple solution.

3 answers

1 accepted

0 votes
Answer accepted
Florin Manaila Feb 19, 2013

If you didn't have the ADMIN account on the backup, or it didn't have the same configuration for external user directories (if you have any), then your ADMIN account is lost.

This will show you how you can get administrator permissions back.

Florin Manaila Feb 19, 2013

I believe JIRA has automatic backup enabled by default, so there's a good chance you have backups from before the restore. Look for them in your <JIRA_HOME>/export folder. If you have any, you can copy one to the import folder and restore the data from it.

Verena Alberg Feb 19, 2013

Unfortunately, I don t know how to manage this solution.

Would it be also possible to use the setup wizard like:

or just to make a new download with the same license key?

If it would be possible to get database back like before the xml-restore. I could first backup and then restore again.

Thanks for your help.

Verena Alberg Feb 19, 2013

I found a backup (, but is there any possibility to restore it without AMIN access?

After the restore I m just a simple user in the Jira database.

Thanks a lot, I'm afraid it went wrong.

Nic Brough [Adaptavist] Community Leader Feb 19, 2013

If you want to revert to that backup, and you don't have admin in the current system, then you have two options:

1. As Florin said, reset the password by following the options in the document given. (But then you probably don't need to restore)

2. Stop Jira, drop all the tables in the database it's using, and restart it. Without it's users and so-on, it will think "Oh I'm new" and offer you a baseline setup or the option to import (even if you go with baseline, you'll at least have an admin account)

However, I'd strongly recommend NOT trying option 2 yet. Could you tell us why you are unable to reset the admin password as per the documentation Florin pointed you at? That's a far better solution

Verena Alberg Feb 19, 2013

The problem is, I don t know how to follow the instructions:

"To find out which group(s) have been granted the JIRA Administrators global permission, run the following database query".

I never worked with databases and I don t know how open it or to start a query.

Nic Brough [Adaptavist] Community Leader Dec 19, 2014

I'm afraid the answer there is that you need to learn. The method varies by database, so start with the documentation for the database you're using.

0 votes
swetha v Dec 19, 2014

-Login into existing jira and create a new user with administrator permissions

- take a xml backup of the data

-keep the xml backup file on new JIRA server in import directory.

- install and access new jira through web browser, create a default admin account in setup wizard, 

- restore the backup file giving the path of xml backup file

- now, you cannot login with the default admin account because the old data gets wiped off after restore. so now login with the user account which you created in jira before taking the backup on old jira server.

0 votes
Nic Brough [Adaptavist] Community Leader Dec 19, 2014

That's the problem - they can NOT get in as an admin, so they can't do this.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

864 views 12 14
Read article

Community Events

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

Events near you