So I'm new to ROR and Heroku and need a little help. I've created an app and have deployed it; however, I'd like to clear out the database associated with it. Meaning I'd like to clear any users (and their attached data) that have been created thus far.
I've basically created several phony accounts to test out whether the database on the production site works, but now i'd like to clear this out, and start with a fresh database.
Is this possible without deleting the database entirely?
Any help would be sincerely appreciated. Thank you very much for your time!
To reset your database
run like bellow
this works very well for my
If you have two servers - production and staging, and you want to add the database from production to staging
URL_TO_DATABASE - an aws or dropbox url for the dump.
This worked for me!
You can use
heroku pg:reset DATABASE
command to reset the entire database. The command will simply drop and create the database.You have to use
heroku rake db:migrate
to create the tables then.Alternatively you can use
rake db:reset
command locally and then runheroku db:push
to update the production db.Heroku provides a visual tool to do this. Go to Resources > Heroku Postgres :: Database Drop database manualy
If you want to migrate your tables use
rake db:migrate
To launch your seedsrake db:seed
Yes, you can either use SQL methods to do it or perhaps just use the Rails Console to do it from the command line and call the @users.destroy_all method. This article explains how to use the console from Heroku.
Login on Heroku through terminal and then run one of following commands:
The first one is an old one and the second is latest.