MySQL conversion from MyISAM to InnoDB is not so simple
Bamboo database definition misses all or most of FOREIGN_KEY definitions.
Naive MyISAM to InnoDB conversion. It is not enough to dump database structure and pull it into newly created database. The problem is that MyISAM database has no FOREIGN_KEY definitions
- run an export of Bambooo (without artifacts and build logs)
- backup BAMBOO_HOME directory and database (database just in case)
- setup a fresh Bamboo instance
- recreate BAMBOO_HOME directory from backup
- import data from previously created export
It is recommend to test this procedure on a separate instance of Bamboo and in case of success simply switch those instances.