Upgrading from MySQL v5.1 to v5.6

[Andres Hermosilla]

I noticed the answer below for a smaller MySQL upgrade, I was wondering if it was safe to make the jump from 5.1 to 5.6

https://answers.atlassian.com/questions/311778

[Rodrigo Girardi Adami]

HI Andres,

I remember that I've answered a question similar to this previously here. Jumping from  5.1. to 5.5 was really simple to me once.

However, the 5.6 implemented several changes in the database structure and might be harder to accomplish.

I do recommend to make this test on a staging environment and perform several tests before deploying on production.

Cheers,

Rodrigo

[Luciano Fagundes]

Andres

Just to complement this topic, you may also refer our Switching Database documentation. It describes how to migrate the entire JIRA database to a different DB server.

https://confluence.atlassian.com/display/JIRA/Switching+Databases

Hope it helps!

Cheer

L.F