Load a structure.sql into a rails database via rake

ruby-on-rails schema
locoboy picture locoboy · Apr 15, 2014 · Viewed 26.1k times · Source

rake db:schema:load will load a schema.rb file into a rails database. Is there a way to load a structure.sql file into the database through rake or do I just need to do this manually?

Answer

Tsutomu picture Tsutomu · Sep 15, 2014

Use rake db:structure:load, which will load db/structure.sql.

[Update]

If you want to load another file, you can specify its path via

  • SCHEMA environment variable (Rails 5.0 or later)
  • DB_STRUCTURE environment variable (Rails 4.x)

For example, run

rake db:structure:load SCHEMA=db/another.sql

or

rake db:structure:load DB_STRUCTURE=db/another.sql

Related questions

How to rollback a specific migration?

I have the following migration file db\migrate\20100905201547_create_blocks.rb How can I specifically rollback that migration file?

Read More
Does rake db:schema:dump recreate schema.rb from migrations or the database itself?

Does rake db:schema:dump recreate schema.rb from migrations or the database itself?

Read More
add_column for references (Rails)

I have the following Rails migration which works perfectly (irrelevant pieces removed): create_table :comments do |t| t.text :body t.references :post end Now I'd like to add an author column to my comments table (which is the userid …

Read More