dump_mysql_databases.rb

#!/usr/bin/ruby

require 'mysql'

begin
  puts "Dumping mysql databases..."

  system("rm -f /root/mysql/*")

  mysql = Mysql.real_connect('localhost','root','password','mysql')
  results = mysql.query("SHOW DATABASES")
  
  results.each do |row|
    puts row
    system("mysqldump -u root #{row} > /root/mysql/#{row}.sql")
    system("bzip2 -9 /root/mysql/#{row}.sql")
  end

  mysql.close
rescue Exception => error
  puts error.message
end