Rails: upload local database to remote

Question

In my Rails App, I scraped many data from other websites, and it's all on my local development database. Now, I want to deploy my website to Heroku, and I want to upload the local data as well, so I don't need to scrape those data again. How can I do it?

I think I can just convert the local data(just a few models) into yml, or csv, and then write a rake task to read from those file.

I'm wondering if there are better approaches.

Have you tried pg:push devcenter.heroku.com/articles/heroku-postgresql#pg-push ? — Nitish Parkar
– Nitish Parkar, Commented May 22, 2015 at 5:01
@cqcn1991 Please do consider accepting the answer if it has helped you in solving your question . — user3620005
– user3620005, Commented May 22, 2015 at 11:04
@GhostBuster I'm about to, but now I'm struggling with other code problem, I'll accept once I test that gem. — ZK Zhao
– ZK Zhao, Commented May 22, 2015 at 11:26

Caffeine Coder · Accepted Answer · 2015-05-22 06:57:26Z

2

I think what you are looking for is this

Allows you to take backup of your db using simple commands and then you just need to restore it on the live database . Quite easy .

answered May 22, 2015 at 6:57

Caffeine Coder

1,8891 gold badge18 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails: upload local database to remote

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related