Create DB in production environment in rails

Question

I have searched for how to create db in production environment for rails and got 2 answers. Now I am confused with those answers.

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

What is the difference between these two? What does this schema means?

Why do we need db:schema:load?

Thanks in advance.

Answer 1

RAILS_ENV=production rake db:create would create the database for the production environment,

whereas

RAILS_ENV=production rake db:schema:load would create tables and columns within the database according the schema.rb for the production environment.

task :load => [:environment, :load_config] do
  ActiveRecord::Tasks::DatabaseTasks.load_schema_current(:ruby, ENV['SCHEMA'])
end

task :create => [:load_config] do
  ActiveRecord::Tasks::DatabaseTasks.create_current
end

Take a look at this file for complete info on the topic.