Home > DeveloperSection > Forums > From heroku server unable to take backup
Glen Martin
Glen Martin

Total Post:27

Posted on    October-01-2015 12:47 AM

 SQLite Database  Sqlite  Sqlite3 

 1 Reply(s)
 607  View(s)
Rate this:

I am unable to take backup of sqlite3 file from heroku server and gettin an error, here is the command I use: command heroku db:pull sqlite:///Users/sample/backup.db.
this is the error:

!    `db:pull` is not a heroku command.
!    Perhaps you meant `pg:pull`.
!    See `heroku help` for a list of available commands.

It seems db command isn't available anymore and I couldn't find a way to backup the sqlite database from heroku.
Please help me how can I take backup?

Tarun Kumar

Total Post:214

Posted on    October-01-2015 8:55 AM

To backup your database from heroku and download the backup, follow the following steps:
create a backup:
heroku pg:backups capture --app your_app_name
create a publicly accessible backup URL:
heroku pg:backups public-url --app your_app_name
Then, curl it down and save it to db_backup.dump file:
curl 'the_db_backup_url' > db_backup.dump

Don't want to miss updates? Please click the below button!

Follow MindStick