Jira and MySQL 8

[Vitaliy Ivanets]

Jira 7.3 stopped working after updating MySQL to v. 8.
We have a backup of jira-homedir and MySQL DB of the previous version (that worked well).
How can we restore Jira without losing data?

[Petr Vaníček · Accepted solution]

Hi,

if you have backup of HOME dir before MySQL upgrade than it could not be hard to recover it.

You can follow up article for migration to another server (it's like your situation).

https://confluence.atlassian.com/adminjiraserver/migrating-jira-applications-to-another-server-938846962.html

Or as first you can try install MySQL 5.7 and recover data into new DB from backup. Than you just need edit config in HOMEDIR/dbconfig.xml. If this not help then follow linked article.

Hope it helps and you will recover it in short time.

In future - be careful with upgrades on Jira server. Everytime check Supported platforms in Jira documentation - like this https://confluence.atlassian.com/adminjiraserver073/supported-platforms-861253018.html

[Deleted user]

Why don't use just support Mysql 8? It works, all you have to do i to quote identifiers.

[Deep Patel]

I'm having issues with mysql 8. When I add 

innodb_large_prefix=ON
innodb_file_format=Barracuda

mysql server is not starting up.

[stockerc]

Per: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-0.html

Important Change; InnoDB: The following InnoDB file format configuration options were deprecated in MySQL 5.7.7 and are now removed:

• innodb_file_format

• innodb_file_format_check

• innodb_file_format_max

• innodb_large_prefix