Rails 3. Creating a production database

Question

How can I create a production database in Rails 3 and load a schema to it?

I tried the following approaches...

I.

rake db:create Rails.env='production' && rake db:schema:load Rails.env='production'

II.

# config/environment.rb
# Set the rails environment
Rails.env='production'
rake db:create && rake db:schema:load

... but neither of them works.

Thanks.

Debian GNU/Linux 5.0.6;

Rails 3.0.0;

Sqlite3 3.7.2.

score 82 · Accepted Answer · edited Jun 25 '15 at 09:44

82

You can set the rails env off of the environment variable RAILS_ENV

RAILS_ENV=production bundle exec rake db:create db:schema:load

should work

edited Jun 25 '15 at 09:44

Ahmed Ali

answered Sep 11 '10 at 06:59

Matt Briggs

2

just watch out that you don't destroy an existing database. if your schema has force => true you could be in for a bad day – Scott Eisenberg Mar 24 '15 at 14:08

score 12 · Answer 2 · edited Jun 24 '15 at 13:03

12

Shouldn't this be

RAILS_ENV=production bundle exec rake db:create db:schema:load

edited Jun 24 '15 at 13:03

Ahmed Ali

answered Apr 07 '11 at 20:55

Victor S

2 Answers2