How do I migrate my heroku database?

Question

I've tried:

heroku rake db:migrate

and

heroku pg:push

The first gives me a PGerror / rake aborted error.

Is there a way to completely rebuild/reset my database with heroku? I can't seem to find it in their documentation.

EDIT: I had a working database before this, but my tables and relationships have changed.

Answer 1

If you had a working database, you could recreate your tables from the schema:

heroku run rake db:schema:load

If you want to just reset the database to empty:

heroku run rake db:create

What is the error it is giving you? It might be more helpful to try to solve that problem rather than wipe everything.

Answer 2

This should be updated as heroku rake has been deprecated. Use heroku run rake now. See below, per command-line/stderr output, as of today (March 8, 2013):

---

Incorrect:

• PROMPT>heroku rake db:migrate --app myApp

  WARNING: 'heroku rake'` has been deprecated. Please use 'heroku run rake' instead.

---

Correct:

• PROMPT>heroku run rake db:migrate --app myApp

  Running rake db:migrate attached to terminal... up, run.2810