my_backup.rb

# encoding: utf-8

##
# Backup Generated: my_backup

Backup::Model.new(:my_backup, 'Description for my_backup') do

  split_into_chunks_of 250

  database MySQL do |db|
    # To dump all databases, set `db.name = :all` (or leave blank)
    db.name               =  :all
    db.username           = "my_username"
    db.password           = "my_password"
    db.host               = "localhost"
    db.port               = 3306
    db.socket             = "/var/run/mysqld/mysqld.sock"
    #db.skip_tables        = ["skip", "these", "tables"]
    #db.only_tables        = ["only", "these" "tables"]
    db.additional_options = ["--quick", "--single-transaction"]
  end

  store_with RSync do |server|
    # server.username = 'my_username'
    # server.password = 'my_password'
    # server.ip       = '123.45.678.90'
    # server.port     = 22
    server.path     = '~/backups/'
    server.local    = true
  end
 
  compress_with Gzip

  notify_by Mail do |mail|
    mail.on_success           = true
    mail.on_warning           = true
    mail.on_failure           = true

    mail.from                 = "[email protected]"
    mail.to                   = "[email protected]"
    mail.address              = "smtp.gmail.com"
    mail.port                 = 587
    mail.domain               = "your.host.name"
    mail.user_name            = "[email protected]"
    mail.password             = "my_password"
    mail.authentication       = "plain"
    mail.enable_starttls_auto = true
  end

end