mysql sync script

local_sync.sh

#!/bin/bash

if [ "$HOSTNAME" = "prod-server-name" ]; then
	echo 'DO NOT RUN ON PRODUCTION!'
	exit
fi

# Create backup / transfer it
ssh user@prod-server-name 'mysqldump --single-transaction -u www -ppassword database | gzip > database.sql.gz'
scp user@prod-server-name:/home/user/database.sql.gz .
ssh user@prod-server-name 'rm database.sql.gz'

# Delete/create DB
sudo -i mysqladmin -f drop database
sudo -i mysqladmin create database

# Copy data
gunzip database.sql.gz
pv database.sql | sudo -i mysql database

# Migrate
./manage.py migrate database

# clean
rm database.sql

echo "### Latest backup for database loaded ###"
echo `date`