Capistrano task to export and import Wordpress database

gistfile1.rb

# Requires WP-CLI on the client and server

namespace :db do
  desc 'Backup Wordpress database to shared/backup/timestamp.sql.gz and create a latest.sql.gz symlink'
  task :backup do
    stamp = Time.now.utc.strftime('%Y%m%d%H%M%S')
    filename = "#{fetch(:application)}_#{stamp}.sql.gz"
    backup_path = "#{shared_path}/backup/#{filename}"
    on roles(:app) do
      execute "mkdir -p #{shared_path}/backup"
      execute "cd #{current_path}; wp db export - | gzip > #{backup_path}"
      execute "ln -sf #{backup_path} #{shared_path}/backup/latest.sql.gz"
    end
  end

  task :pull do
    desc 'Import backup database and overwrite local Wordpress'
    ask :answer, 'Are you sure you want to overwrite your local database? [y/n] '
    if fetch(:answer) == 'y'
      on roles(:app) do |server|
        run_locally do
          execute "ssh #{server.user}@#{server.hostname} 'cat #{shared_path}/backup/latest.sql.gz' | gunzip | wp db import -"
        end
      end
    else
      puts 'Cancelled'
    end
  end
  before 'db:pull', 'db:backup'
end