Need help on upgrade MySQL 8.4.0 from MySQL 5.7.32?

[Tejas Naik]

Hi,

We’ve reached the end of support for Confluence 7.18.1, so we are planning to upgrade to Confluence 8.9.6. During the upgrade process, we discovered that we need to upgrade MySQL from version 5.7 to 8 before upgrading Confluence.

I’ve reviewed the documentation but am still unclear about how to perform an in-place upgrade of MySQL 8 using the binary package since our current MySQL 5.7 was installed via binaries.

My question is: Can we take a backup of MySQL 5.7.32, extract the file MySQL 8.4.0, and run the mysql_upgrade command and update the my.cnf file?

Or should I extract the file MySQL 8.4.0, create a new database, and load the data from the old MySQL 5.7.32 dump?

This is my first time handling a database upgrade, I would greatly appreciate your guidance or any specific documentation that could help.

Regards
Tejas

[Fadoua]

@Tejas Naik 

Good Day!

I hope the following links will help:

• https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15
• https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

Best of luck!

Fadoua

[Tejas Naik]

Hi @Fadoua 

Thank you for the response

https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

The link you provided suggests migrating from a different database, but I’m specifically looking to upgrade the same database to a higher version, from MySQL 5.7 to MySQL 8.4.0.

[Fadoua]

@Tejas Naik  Then please refer to the Microsoft documentation. I was unable to locate a doc on Atlassian website which makes sense because MS should provide it