backup-databases

#!/usr/bin/env ruby 

%w(rubygems hpricot).each { |lib| require(lib) }

if ARGV.length < 2
  
  puts "Usage:   './backup-databases /path/to/backups label databases,to,ignore'"
  puts "Example: './backup-databases /tmp/db-backups weekly mysql,information_schema,test'"

else

  output_path = ARGV[0]
  label = ARGV[1]
  ignore = ARGV[2] ? ARGV[2].split(',') : []

  databases = (Hpricot(`mysql -u root -e "show databases" -X`)/'resultset'/'row'/'field').collect { |row| row.inner_html }

  `mkdir -p #{output_path}`

  (databases-ignore).each do |database|
    `mysqldump -u root #{database} > #{output_path}/#{database}.#{label}.sql`
    print('.'); $stdout.flush()
  end

  puts ''

end