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

[pupie]

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.

[Alexey Chystoprudov]

Hello @pupie cn,

Please follow steps below:

1. Stop any Atlassian applications using the MySQL instance
2. Dump each database that needs to be recreated
   eg: mysqldump --databases bamboo > bamboo.sql
3. Use DROP DATABASE to drop each database that you're recreating
4. Stop the MySQL service
5. Add lower_case_table_names=1 to your MySQL configuration file
6. Restart MySQL service
7. 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

[Boris Capitanu]

Great, this worked for me as well.

[pupie]

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