#!/bin/bash

`ssh user@prod-server.com << EOF
mysqldump --user prod_user --password=prod_password prod_database > site_name.sql
exit`

scp user@prod-server.com:/path/to/backup/site_name.sql site_name.sql

`mysql -udev_user -pdev_user_pass -h dev-server-mysql.com << EOF
DROP DATABASE development_database;
CREATE DATABASE development_database;
exit`

mysql -udev_user -pdev_user_pass -h dev-server-mysql.com development_database < site_name.sql