Rails import database on heroku

Question

I am trying to import a database from my computer to heroku but it keep on saying unknown command for that.Even I am confuse about it which command to use .I have a postgre sql database.I want to know how to import a database

   push from SOURCE_DATABASE to REMOTE_TARGET_DATABASE
 REMOTE_TARGET_DATABASE must be empty.

 SOURCE_DATABASE must be either the name of a database
 existing on your localhost or the fully qualified URL of
 a remote databas

So what will be the remote_target_database ??? and do i need to specify my full path to source database ?

The error message is helpful. You want `heroku pg:push` not db:push — eugen, Jan 27 '16 at 10:09
It obviously says: `Perhaps you meant "pg:push"`. Did you try that instead? — Tamer Shlash, Jan 27 '16 at 10:10
Add that to the question body instead of writing it in the comments please. — Tamer Shlash, Jan 27 '16 at 10:11
This link might help you: https://devcenter.heroku.com/articles/heroku-postgresql#pg-push — Tamer Shlash, Jan 27 '16 at 10:13
that article I have already seen that but was having some doubt — Aniket Tiwari, Jan 27 '16 at 10:24

score 3 · Accepted Answer · answered Jan 27 '16 at 10:20

3

Try the following.

heroku pg:push your_app_name_development DATABASE_URL

answered Jan 27 '16 at 10:20

Dheeresha

797
1
4
6

heroku pg:push my_Database_name it is showing me error – Aniket Tiwari Jan 27 '16 at 10:22
This worked for me! by `your_app_name_development` did you mean something more like `development_database_name`? – Chris Scott Jul 17 '18 at 18:09

score 0 · Answer 2 · edited May 23 '17 at 12:08

0

PG Backups can be used as a convenient tool to import database dumps from other sources into your Heroku Postgres database.

edited May 23 '17 at 12:08

Community

1
1

answered Jan 27 '16 at 10:14

Rahul Kumar Das

101
2

Rails import database on heroku

2 Answers2