namespace(:deploy) do
task :mysqldump, :roles => :app do
text = capture "cat #{shared_path}/database.yml"
yaml = YAML::load(text)
run "mysqldump --opt #{yaml['mysql']['database']} -h #{yaml['mysql']['host']} -u #{yaml['mysql']['username']} -p#{yaml['mysql']['password']} | gzip > #{shared_path}/backups/#{Time.now.to_i}.sql.gz"
end
end