Rails backup database task

backup.rake

require 'backup'
namespace :backup do
  desc "Backup database."
  task :db => ['db:load_config'] do
    config = ActiveRecord::Base.configurations[Rails.env]
    Backup::Model.new(:rake, 'backup') do
      store_with Backup::Storage::Local do |local|
        local.keep       = 5
        local.path = Rails.root.join('backups')
      end

      database Backup::Database::MySQL do |db|
        db.name     = config['database']
        db.username = config['username'] || 'root'
        db.password = config['password'] if config['password']
        db.host     = config['host']     || 'localhost'
        db.port     = config['port']     || 3306
        db.socket   = config['socket']   || "/var/lib/mysql/mysql.sock"
        db.additional_options = ["--quick", "--single-transaction"]
      end
    end.perform!
  end
end