Rails database.yml question when using Amazon RDS

Question

How should my database.yml production look like when I am using Heroku and Amazon RDS?

My database.yml

# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
# gem 'mysql', '2.8.1'

    development:
      adapter: mysql
      database: konkurranceportalen
      encoding: utf8
      pool: 5
      username: root
      password: 
      socket: C:/xampp/mysql/bin/mysqld.sock
      host: 127.0.0.1

    # Warning: The database defined as "test" will be erased and
    # re-generated from your development database when you run "rake".
    # Do not set this db to the same as development or production.

    test:
      adapter: mysql
      database: rails_t
      encoding: utf8
      pool: 5
      username: root
      password: 
      socket: C:/xampp/mysql/bin/mysqld.sock
      host: 127.0.0.1

    production:
      adapter: mysql
      database: rails_t
      encoding: utf8
      pool: 5
      username: root
      password: 
      socket: C:/xampp/mysql/bin/mysqld.sock
      host: 127.0.0.1

score 0 · Accepted Answer · answered Mar 19 '11 at 11:29

0

see the Heroku docs for details of the Amazon RDS addon - here

answered Mar 19 '11 at 11:29

John Beynon

37,398
8
88
97

I have read the guide. But when I try to push my MySql database to Amazon RDS I get this error http://stackoverflow.com/questions/5357486/heroku-help-amazon-rds-rails-push-database-error – Rails beginner Mar 19 '11 at 12:32

score 0 · Answer 2 · edited May 23 '17 at 11:51

0

View my walkthrough for solving this issue here: Heroku help deploying Rails app that uses Mysql database

edited May 23 '17 at 11:51

Community

1
1

answered May 02 '11 at 03:51

Timothy Britt

711
6
6

Rails database.yml question when using Amazon RDS

2 Answers2