ERROR: relation "places" does not exist Heroku db import

Question

I know this kind of error happens when having quotes or case sensitivity error in the query of postgres . Actually i'm having a .sql file which i'm trying to import in my heroku db through command line but constantly having this error .My .sql file contains these queries

INSERT INTO "places" ("Name", "Address") VALUES
('Cookshop Restaurant &amp', ' Bar'),
('Cafeteria', '119 7th Ave, New York, NY 10011'),
('Franchia Vegan Cafe', '12 Park Ave, New York, NY 10016');

Answer 1

The problem is heroku doesn't have the migrations that you locally have, in order to have the same db version do the following migration on heroku:

To know the local db version do: $ rake db:version

Then take the version you get locally and make sure you have it in heroku by doing the following:

$ heroku run rake --trace db:migrate VERSION=20151127134901

Explanation: Essentially the above command takes the db migration to heroku with the same version of migration you have locally.

Hope it helps!