Help us understand the problem. What is going on with this article?

AlminiumのDBをyaml化してバックアップ

More than 5 years have passed since last update.

yml化することで、redmineで使うDBを sqlite3<-->mysql 切り替える事ができる。

yaml_db
# cd /opt/alminium
# echo "gem 'yaml_db'" >> Gemfile.local
# bundle install
# RAILS_ENV=production bundle exec rake db:data:dump
  • /opt/alminium/db/data.yml が生成される。

alminium -> Redmine3への移行

dump
mysqldump -ualminium -palminium alminium > alminium.sql
以下実行してからyaml化
DROP TABLE banners;
DROP TABLE chart_done_ratios;
DROP TABLE chart_issue_statuses;
DROP TABLE chart_time_entries;
DROP TABLE code_review_project_settings;
DROP TABLE rb_issue_history;
DROP TABLE rb_project_settings;
DROP TABLE rb_release_burndown_caches;
DROP TABLE repositories;
ALTER TABLE issue_statuses DROP is_default;
ALTER TABLE issue_statuses DROP position;
ALTER TABLE issues DROP position;
ALTER TABLE issues DROP release_id;
ALTER TABLE issues DROP release_relationship;
ALTER TABLE issues DROP remaining_hours;
ALTER TABLE issues DROP story_points;
ALTER TABLE users DROP mail;
ALTER TABLE users DROP mail_notification;
load
RAILS_ENV=production bundle exec rake db:data:load
docker run -d --name redmine3 redmine

新しいチケットを作成しようとするとエラーが出る場合

aa.png

デフォルトのチケットステータスが定義されていません。設定を確認してください(管理→チケとのステータス)。

トラッカー のデフォルトステータスが空の場合、上記メッセージが出た。

ab.png

デフォルトのステータスを選択し保存にて解決。

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした