nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to update MySQL 5.5 to 5.6 or higher on Confluence 5.10?

Mara Broeker

I want to update our running Confluence Server Version 5.10 to 6.x. I saw that i need to update MySQL first because MySQL 5.5 will not work with Confluence 6.x.

I am completly new to updating these systems. Is there any How-To/Step-by-step guide about upgrading the MySQL version? I saw a lot about new installations but i think this is not what i am searching for.

Thank you so much!

Regards,

Mara

Accepted answers

Igor M_

Hello,

If you have a small enough instance to take an XML backup of the entire site, then safest method with least amount of downtime or potential for failure would be to install a new DB version running MySQL 5.6, then configure it to match Database Setup For MySQL configuration guide. Then proceed with installing new Confluence 5.10 using new DB. Once you are past DB setup part of installer, you will be prompted to restore data, that is where you can restore your xml backup.

If your instance is too large for XML backup, then you can attempt data in place upgrade, but MySQL recommends DB dump and restore on newer version too, as described in MySQL Upgrade Strategies

MySQL recommends a mysqldump upgrade when upgrading from a previous release. For example, use this method when upgrading from 5.5 to 5.6.

This method will also involve DB dump and restore, as no xml backup is used, you can then connect your Confluence instance to new DB by modifying Confluence's database connection parameters to point Confluence to new DB.

Parameters from "my" file described in Database Setup For MySQL guide must be present regardless of which method you use, xml restore on new site or database dump and restore on newer version.

Let me know if you have any questions.

Regards,

Igor

All comments

Igor M_

Hello,

If your instance is too large for XML backup, then you can attempt data in place upgrade, but MySQL recommends DB dump and restore on newer version too, as described in MySQL Upgrade Strategies

MySQL recommends a mysqldump upgrade when upgrading from a previous release. For example, use this method when upgrading from 5.5 to 5.6.

Parameters from "my" file described in Database Setup For MySQL guide must be present regardless of which method you use, xml restore on new site or database dump and restore on newer version.

Let me know if you have any questions.

Regards,

Igor

Mara Broeker

Hi Igor,

Thanks a lot! The information is very helpful. I really appreciate your quick answer.

Do i need the installer to go through these instructions or can i do it manually?

Regards,

Mara Bröker

Igor M_

Hey, glad I could be of help,

What installer are you referring to? If you are referring to Confluence or MySQL executable installer file, you would still need to manually set parameters in accordance to best practice guide for Confluence running on MySQL.

If I misunderstood your question, please let me know.

Mara Broeker

Hi,

thanks again for your reply it helped me a lot!

Regards and have a nice day!

Mara

Igor M_

Hello, it's the same procedure, we leave for DBAs to decide how to upgrade their Database, as long as it's

In line with DB vendor best practices and procedures
Adequate backups were made prior to upgrade
DB has the right best practice settings required for Confluence, like character encoding

Hope this helps

Igor

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server