How can I import a SQL file into a Rails database?

Question

I've got a .sql file that I'd like to load into my Rails database using a Rake task. How can I do this?

Answer 1

The easiest way:

bundle exec rails db < $SQL_FILE 

example:

bundle exec rails db < my_db.sql