Database migration from mysql 5.5 to mysql 5.7 for Confluence

[Arpit Sharma]

Hi,

Can anybody help me regarding migration of mysql 5.5 to mysql 5.7? I done with simple export import. But it doesnt work. Is there any process or guidelines for this? 

Thanks & Regards
Arpit

[JP _AC Bielefeld Leader_]

Hi Arpit,

create a replica / copy of your current 5.5.46 server with all databases on that server. Upgrade that server to 5.6 (lastest). Run mysql_upgrade after upgrading the binaries & starting the server. If you get no errors, stop the server & upgrade to 5.7 (latest). Run mysql_upgrade afterwards & fix any possible errors. Check, if any MySQL settings must be configured to match the system requirements for your Confluence version (Charset, Collation on server, database & tables, Transaction settings,...).

Start a staging/test instance of your Confluence server configured to use that server.

Concerning your import / exports: Do you refer to a Confluence XML export & import or a database dump and reload?`This is a big difference. If you refer to a database dump make sure you create the database user & permissions on the database, so that Confluence can access the database.

Anything in the application log of Confluence?

Best

JP

[kennyngkk]

Hi Arpit, 

Can you further elaborate on how it is failing and what are the steps are you using to import/export the database? 

[Arpit Sharma]

Hi Kenny Ng,

We have confluence setup with external database(mysql 5.5.46). I exported database here and imported in mysql 5.7.23. After that I have changed ip of database server in configuration file of confluence. But it doesnt work for me. I restarted the service but there is no main page on url. 

[kennyngkk]

Hi Arpit, 

This is my suggestion. Create another database MySQL 5.5.46 instance and import that from your production instance. once that is done, done upgrade to 5.7.23 after upgrading point Confluence to the instance itself. 

You have other option that you can perform this database upgrade/migration

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