How to Restore Production Jira to Development?

[Balaji J]

We have a practice to restore production to lower environments periodically and we will need to do for JIRA now. 

Any specific tables in Jira DB we need not refresh?

Any additional steps apart from below to be executed? 

1. Disable email sending/receiving by uncommenting DISABLE_NOTIFICATIONS

2. Stop Jira
3. Replace the Dev Jira Home directory with the Prod Home directory.
4. Restore the database from prod to dev.
5. Start Jira 

[Balaji J]

Thanks all . Sorry for late reply but everything went fine except license update , when we restored prod DB to development license also updated. Can you suggest how we can take care of this?

[Balaji J]

Any help will be appreciated.when we restored prod DB to development license also updated. Can you suggest how we can take care of this?

[Alexey Matveev]

Hello,

You can copy the whole database form production.

Just do not forget to switch of outgoing mail and incoming mail because users will get mail from your dev environment and also your dev environment will intercept incoming mail.

We execute scripts after we moved database from production to dev. We deal with mail, change baseurl, change colours, change banner and change plugin settings if necessary.

[Vishnukumar Vasudevan]

You also have to take care of authentication part if it's connected to crowd. You will have to create new account for Dev instance in Crowd and update it in the config file. 

And add 'Reindexing' also after starting JIRA.

[Alexey Matveev]

You can get your developer license from the Atlassian site and update it manually. If you want to automate the process, then you can change the license via sql queries. You can find more info here:

https://confluence.atlassian.com/jirakb/how-to-get-and-update-jira-license-string-from-the-database-441746313.html