Importing database dump in Ruby on Rails

1. Unzip the data.

2. Drop the database that you have in your local, you can drop it in two ways

a. rails db:drop

b. You can login to your database like for e.g if you are using psql, just type psql, then do drop mydatabase .

3. Now we need to create the database. Again from rails directory you can do either

a. rails db:create

b. create mydatabase .

4. Now you can load your unzipped database by doing either of the given below steps

a.rails db < mydatadump

b.psql -u username -p password mydatabase < mydatadump