I tried to follow this guide by Heroku but the solution was lacking a little bit of context.
This is what I did:
First get the name of the database checking your
database.yml file on rails.
you should export your local database using
PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb.dump
ommit PGPASSWORD=mypassword if you don’t have one and also ommit the user if you don’t have one.
My final command ended up like this:
pg_dump -Fc --no-acl --no-owner -h localhost database_name > mydb.dump
Upload your file and make it publicly accesible.
Most of the guides will recommend S3 but Dropbox is ok just don’t use Drive since it will corrupt your upload and it will not work most of the time.
After all of that get the public link.
heroku pg:backups:restore 'YOUR_LINK_TO_FILE' DATABASE_URL
DATABASE_URL must be left like that. Just make sure to do all of this inside your app folder so that Heroku knows which app you want to restore.
It will ask you to confirm.
You’ll know if it works because the confirmation message should be:
Let me know if you want me to create a guide to use S3 since it’s quite a challenge if you are starting out.
If you want to receive my latest essays and interesting finds subscribe to my list: