How to upgrade bamboo to 5.13 without affecting Bitbucket/JIRA on same database.

Question

According this page:https://confluence.atlassian.com/bamboo/mysql-289276817.html

Upgrading Bamboo to 5.13 should change mysql parameter and set lower_case_table_names=1.

But I have all other Atlassian instances on the same mysql database such as jira/bitbucket/confluence.

I don't have this setting on my previous installation on centos with mysql, but after changing  lower_case_table_names=1.

other instances can't be started anymore.

Boris Capitanu · Answer

Great, this worked for me as well.

pupie · Answer

Thanks for your answer, I tried with JIRA, it works.

Alexey Chystoprudov · Answer

Hello @pupie cn,

Please follow steps below:

* Stop any Atlassian applications using the MySQL instance
* Dump each database that needs to be recreated
eg: mysqldump --databases bamboo > bamboo.sql
* Use DROP DATABASE to drop each database that you're recreating
* Stop the MySQL service
* Add lower_case_table_names=1 to your MySQL configuration file
* Restart MySQL service
* Reload the mysqldump files:
eg: mysql < bamboo.sql

You should do these steps for every DB you have in your MySQL instance. If you do all that points other Atlassian products will be not affected