#!/usr/bin/ruby
# ---------------------------------------------------------------------
# MySQL Backup Utility
# Usage: ./mysql_backup.rb or ruby mysql_backup.rb
# ---------------------------------------------------------------------

$backup_archive = true # gzip files after processing
$backup_dir = "/home/storage/backup/" # output directory
$backup_template = "project-%s-%s.sql" # text-%dbname-%timestamp.sql
$backup_cmd = "mysqldump -u local_backup --add-drop-table --databases %s > %s" # command to backup
$backup_dblist = [ # list of databases to backup
	'main', 
	'users', 
	'admin', 
	'cards'
] 

def backup_database(database) 
	time = Time.now()
	time_str = sprintf("%02i-%02i-%04i-%02i%02i%02i",time.day,time.month,time.year,time.hour,time.min,time.sec)
	filename = sprintf($backup_template,database,time_str)
	filename = "#{$backup_dir}#{filename}"
	
	cmd = sprintf($backup_cmd,database,filename)
	if system(cmd) then
		system("gzip --best #{filename}") if $backup_archive
	end
end

$backup_dblist.each do |db|
	puts "Processing database... #{db}"
	backup_database(db)
end