BackupIt

Only running on ruby 1.8 not 1.9

$ gem install backupit

storage :file do
  path '/opt/backup/'
  mysql_check true
  postgresql_check true # make sure the user in postgresql_config is the one who run this script and have dropdb & createdb permission
  gpg_enable true
  mysql_config({:host=>"localhost",:user=>"root",:password=>"test",:database=>"checkdb"})
  postgresql_config({:host=>"localhost",:user=>"root",:password=>"test",:database=>"checkdb"})
  gpg_id 'gpg_name' #use user id would be great
end

server 'delonghi' do
  host "delonghi@10.0.1.1"
  port "222"

  rsync ['/home/www/app/shared/config',{'/home/staging/app/shared/config' => 'staging_config','rsync_arg' => 'q','use_sudo' => true }, '/home/www/app/shared/attachments']
  rsync_compress_level '3'

  mysql 'delonghi' do
    user      'root'
    password  'mypassword'
    options   '-h 192.168.1.100'
    databases ['delonghi-staging', 'delonghi-production']
    tables    ['users','products'] # this would overwrite databases! `man mysqldump` for more help.
    skiptables ["delonghi-staging.users", 'delonghi-production.products']
    # skiptables "delonghi-staging.products"
    check true
  end

  mysql 'delonghi_dev' do
    user      'root'
    password  'mypassword'
    options   '-h 192.168.1.100'
    databases 'delonghi-dev'
    tables    ['users','products'] # this would overwrite databases! `man mysqldump` for more help.
    skiptables "user" #=> "delonghi_dev.user"
    check true
  end
end

server 'onitsukatiger' do
  host "otiger2@192.168.1.4"

  mysql 'ot_staging' do
    user      'root'
    password  'mytopsecret'
    databases 'ot_staging'
    check false
  end

  postgresql 'app' do
    user      'root'
    password  'mytopsecret'
    databases 'ot_staging'
    tables    ['users','products']
    skiptables "user" #=> "app.user"
  end
end

1, backup --pretend -f /opt/backup/backup.rb delonghi
   only backup server 'delonghi'  (pretend to run)
2, backup -f /opt/backup/backup.rb
   backup all servers
3, in storage , mysql_check(true | false) and mysql_config to check the backup can be restored
4, in every mysql role, check mean to check the backup or not
5, in rsync,{} path or files only in first place
6, rsync_compress_level , default is 5