automate db backup of live site

[bluebindu]

1. cron (free for daily)

to automate tasks that you want to run - like the pgbackups task in the previous item - create a rake file lib/tasks/cron.rake then add your code within a 'task :cron => :environment' block and it will be executed daily. The timing of this cron job is at the same time every day as the time you added the cron addon

$ heroku addons:add cron:daily

There's a nice gem to manage backups easily and store them in S3 which you can use by adding this to your Gemfile

gem 'heroku_backup_task'

and then adding a simple rake task in lib/tasks like this

require "heroku_backup_task/tasks" task :cron => :heroku_backup