Need help on upgrade MySQL 8.4.0 from MySQL 5.7.32?

Question

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

Andreas Wollenhaupt · Answer

How is Microsoft responsible for mysql?

Tinker Fadoua · Answer

@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

Tejas Naik · Answer

Hi @Tinker 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.