#!/usr/bin/env ruby
require "date"

DBS = %w(database names)
USER = "root" # Username with rights to all those databases
PW = "" # Password for that username

today_s = Date.today().to_s
yesterday_s = (Date.today()-(2)).to_s

DBS.each do |db|
  system "/usr/bin/mysqldump --user=#{USER} --password=#{PW} -t --opt -icC #{db} > ~/home/dbs/#{today_s}-#{db}.sql"
  if File.exist?("/home/dbs/#{yesterday_s}-#{db}.sql")
    File.unlink("/home/dbs/#{yesterday_s}-#{db}.sql")
  end
end