desc "mysqldump from build for the Canadians"
  task :mysqldump do
    system("rm -rf mysql-dump && mkdir -p mysql-dump")
    system("ssh build \" mysqldump -ucanada --password='#{mysql_info}' global_comms_staging | gzip > globalcomms.sql.gz\"")
    system("scp -r build:globalcomms.sql.gz mysql-dump/globalcomms.sql.gz")
    system("ssh build \"rm globalcomms.sql.gz\"")
    system("ssh build \"mkdir -p /tmp/globalcomms-csv && chmod 777 /tmp/globalcomms-csv\"")
    system("ssh build \"mysqldump --user=canada --password='#{mysql_info}' --tab=/tmp/globalcomms-csv/ --fields-terminated-by=, --fields-enclosed-by=\\\\\\\" global_comms_staging\"")
    system("ssh build \"tar czvf globalcomms-csv.tar.gz /tmp/globalcomms-csv\"")
    system("scp -r build:globalcomms-csv.tar.gz mysql-dump/globalcomms-csv.tar.gz")
    system("ssh build \"rm globalcomms-csv.tar.gz && rm -rf /tmp/globalcomms-csv\"")
  end