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.

 

最終更新日 2013 年 7 月 5 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.