Be aware that if you clear out that directory, those database dumps will get deleted. All of the databases get downloaded to the tmp directory so that they don’t get tracked by Git. The task handles downloading and importing the Heroku database for the specified app environment, as well as backing up your local database in case you want to restore it at some point. I broke down the various steps into descriptive methods for easy reference. def run_migrations `bin/rake db:migrate` end end endĪs you can see above, this defines the two previously mentioned Rake tasks bin/rake db:import:staging and bin/rake db:import:production. def import_db ( environment, heroku_app_name ) puts ( 'Importing # ` end # Runs migrations against the just imported database dump from Heroku. # lib/tasks/db_import.rake namespace :db do namespace :import do desc 'Import Heroku Staging database locally' task :staging do import_db ( 'staging', 'YOUR_STAGING_HEROKU_APP_HERE' ) end desc 'Import Heroku Production database locally' task :production do import_db ( 'production', 'YOUR_PRODUCTION_HEROKU_APP_HERE' ) end # Creates a unique database dump based on the current time and specified environment. Here’s the annotated source for the Rake task: You could use a command flag to specify the environment, but I like doing it as part of the task name. It’s easy enough to create a different task for each environment, like bin/rake db:import:staging. That task is bin/rake db:import:production. In the past, I’ve created shell scripts to the run all of the commands, but I recently had the idea 💡 to create a Rake task that is easy to memorize and better fits within the paradigms of a Rails app. To do this, you would need to do the following steps:Įach of those steps requires a different command, which I can never memorize.

You may want to import a Heroku database locally to replicate and fix an issue or to quickly set up a non-trivial amount of data for development. Over the years that I’ve been working with Ruby on Rails applications hosted on Heroku, I’ve regularly needed to import the database from Heroku into my local development environment.

Psql restore dump mac os 10.12