Capistrano backup database

deploy.rb

  desc "Backup and download database"
  task :backup do
    filename = "#{Time.now.strftime("%Y-%m-%d-%H-%M")}.sql"
    run "mysqldump -u #{user} -p#{password} #{application}_prod > /tmp/#{filename}"
    download "/tmp/#{filename}", "backups/#{filename}"
  end