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

This widget could not be displayed.

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?

This widget could not be displayed.

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

This widget could not be displayed.

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 Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

201 views 1 3
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