Switch database under JIRA - a question

Hi,

I'm migrating JIRA projects from version 4 to version 6.1.7. Therefore I have two intermediate JIRAs: a version 5 and a version 6.1.7.

When I restored the backup xml in JIRA v5 and did the mappings, changes then I switched the database: simply changed the dbconfig.xml of JIRA v6 to the same database (db of JIRA v5). Then I logged in to JIRA v6 and everything was fine.

Now my problem is that tomorrow I do the real migration: again from start: backup from JIRA v4 -> restore in JIRA v5.

Right now the database of JIRA v5 is the database of JIRA v6 which is upgraded, so - as I guess - this database won't let the XML of JIRA v4 in.

What could I do now? If a create a new database scheme in MySQL and connect it to JIRA v5..what will happen? Can I login to JIRA 5?

Could you please help?

Thanks in advance,

Rumi

3 answers

Can you give a concise description of what your current situation is? I'm not sure which environments you have and what their status is. At first you made it sound like you did your tests in a development environment and now you want to do them in the production. But then you mention that your production is already at version 6? Are you trying to move your test database into production?

Hi DJX,

I did a test migration: a created a backup in the source JIRA which is version 4.3 and then I restored this backup in a version 5 JIRA. The target JIRA is of version 6.1.7 so I setup another 6.1.7 JIRA. For upgrading backup from version 5 to 6.1.7 I simply switched database under 6.1.7: I connected to it the database of version 5.

Then I created backup in 6.1.7 and then I imported the involved projects into the target JIRA.

Now I have to do it everything again live. The problem here that - I guess - I cannot reconnect database from 6.1.7 to 5 because it would be a downgrade which is impossible.

What can I do now that I get back an available version 5 JIRA? Create a new scheme in MySQL?

Thanks,
Rumi

Hello Rumceisz,

my suggestion is :

1. Create two empty db (one for JIRA 5.X and one for JIRA6.1.7)

2. Backup your JIRA 4.X version

3. Install a new JIRA 5.X from scratch, pointing to the clean JIRA 5.X db, and restore your JIRA4.X backup.

4. Backup your JIRA5.X

5. Install a new JIRA 6.X from scratch, pointing to the clean JIRA 6.X db, and restore your JIRA5.X backup.

Moreover, using this approach, if something goes wrong, you can rollback to your current prod (JIRA4.X).

Hope this helps,

Fabio

Hi Fabio,

thanks!

you're welcome

Please mark my answer as accepted.

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 ...

2,934 views 12 18
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