Capistrano - Load a Mysql dump from a host to local machine

content.rake

import 'config/local.rb'

namespace :content do
    desc "Fetch database from target environment"
    task :pull do
        on roles(:web) do |host|

            file_name = "content-#{fetch(:stage)}-" + Time.now.to_i.to_s

            execute "mysqldump --opt -Q #{fetch(:database_name)} > db.sql"
            
            execute "tar czf #{file_name}.tar db.sql --remove-files"
            
            run_locally  do
                execute "scp #{host.user}@#{fetch(:host_name)}:~/#{file_name}.tar ."

                ask :load, "Do you want to load the retrieved dump into your local database? Y/n", "y"

                if (fetch(:load) == "y")
                    execute "tar xvf #{file_name}.tar"
                    execute "mysql #{fetch(:local_database_name)} < db.sql"
                    execute "rm db.sql"
                end               
            end 

            execute "rm #{file_name}.tar"
        end
    end
end

local.rb

# Contains local settings, used for local tasks

set :local_database_name, 'DBNAME'