How to automate the JIRA data refreshment from Production to Dev/Test

Question

Hi All,

We need to refresh the Dev instance automatically from Production environment. It should be automate process. How to do it.

Alexis Robert · Answer

It depends on what database you're using for Jira. For MySQL for example, you can use "mysqldump" to perform export/import operations on your database. This page can help you get started.

Saravanan Ravikumar_8rsi04 · Answer

Hi Alexis,

Thanks for your response. Could you explain more on this. Any supporting document for this to check.

Alexis Robert · Answer

Hi @Saravanan Ravikumar,

if you're looking to automate the data refresh from Jira, I guess you can do a database dump from prod and import to test instance, with a cron job for example it's trivial.

You could also synchronyze some other files (attachements for example) with rsync.

Let me know if you have any questions,

--Alexis