1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

  production:
    <<: *default
-   database: hashlog_production
-   username: <%= Rails.application.credentials.production[:database][:username] || 'hashlog' %>
-   password: <%= Rails.application.credentials.production[:database][:password] %>
-   host: database-1.cwywibfxqfpp.ap-northeast-1.rds.amazonaws.com
+   # ここのDB_NAMEなどは何でもいいけど、heroku config:setのときの変数名と対応させる
+   database: <%= ENV['DB_NAME'] %>
+   url: <%= ENV['DB_URL'] %>
+   username: <%= ENV['DB_USERNAME'] %>
+   password: <%= ENV['DB_PASSWORD'] %>
+   host: <%= ENV['DB_HOSTNAME'] %>

1
2
3
4
5
6
7

heroku create hashlog # 名前を指定しなかったらランダムになる
Creating ⬢ hashlog... done
https://hashlog.herokuapp.com/ | https://git.heroku.com/hashlog.git

git push heroku heroku_branch:main # `heroku_branch`はローカルのブランチ名

heroku run rake db:migrate

1
2
3
4

# 本番で
mysqldump -u ユーザー名 -h ホスト名 -p データベース名 > dump.sql
#
scp -i "aws-key.pem" username@1.1.1.1:/var/www/hashlog/dump.sql ~/Desktop

1
2
3
4
5
6
7
8

DROP TABLE IF EXISTS `schema_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `schema_migrations` (
  `version` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

1
2
3
4
5

2021-01-31T15:52:12.371735+00:00 app[web.1]: I, [2021-01-31T15:52:12.371666 #13]  INFO -- : [b1a8e225-5191-4b78-a72c-fed3c4910f9a] Completed 500 Internal Server Error in 72ms (ActiveRecord: 6.3ms)
2021-01-31T15:52:12.434617+00:00 app[web.1]: F, [2021-01-31T15:52:12.434526 #13] FATAL -- : [b1a8e225-5191-4b78-a72c-fed3c4910f9a]
2021-01-31T15:52:12.434677+00:00 app[web.1]: F, [2021-01-31T15:52:12.434619 #13] FATAL -- : [b1a8e225-5191-4b78-a72c-fed3c4910f9a] ActiveRecord::StatementInvalid (Mysql2::Error: Table 'heroku_eb9b292d281ded2.users' doesn't exist: SHOW FULL FIELDS FROM `users`):
2021-01-31T15:52:12.434724+00:00 app[web.1]: F, [2021-01-31T15:52:12.434679 #13] FATAL -- : [b1a8e225-5191-4b78-a72c-fed3c4910f9a]
2021-01-31T15:52:12.434776+00:00 app[web.1]: F, [2021-01-31T15:52:12.434731 #13] FATAL -- : [b1a8e225-5191-4b78-a72c-fed3c4910f9a]

1
2
3
4
5
6
7

[aiandrox@ip-10-0-11-43 hashlog]$ RAILS_ENV=production rails c
Running via Spring preloader in process 22420
WARNING: Spring is running in production. To fix this make sure the spring gem is only present in `development` and `test` groups in your Gemfile and make sure you always use `bundle install --without development test` in production
Loading production environment (Rails 5.2.4.4)

irb(main):001:0>  Rails.application.credentials.secret_key_base
=> "hogehogehoge" # これをコピー

1

$ heroku config:set SECRET_KEY_BASE="hogehogehoge"

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

$ heroku addons:create scheduler:standard --app hashlog

Creating scheduler:standard on ⬢ hashlog... free
 To manage scheduled jobs run:
 heroku addons:open scheduler

Created scheduler-trapezoidal-55864
Use heroku addons:docs scheduler to view documentation

$ heroku addons:open scheduler