#!/bin/sh
readonly RMNAME="stage.pl2"
readonly RMUSER="dev"
readonly RMPASS="bardzotrudnehaslonumer1"
readonly RMADDR="ajslandum.kom"

readonly DBNAME="stage.pl2"
readonly DBUSER="root"
readonly DBPASS="bardzotrudnehaslo"

FILENAME=~/dumps/$RMNAME.$RMADDR.`date +%s`.sql


echo "-- ZRZUCENIE BAZY Z SERWERA"
mysqldump -u $RMUSER -p$RMPASS -h $RMADDR $RMNAME --single-transaction --routines | pv > $FILENAME

echo "-- PRZYGOTOWANIE BAZY --"
echo "DROP DATABASE IF EXISTS \`$DBNAME\`; CREATE DATABASE \`$DBNAME\`" | mysql -u$DBUSER -p$DBPASS

echo "-- WRZUCANIE DO BAZY --"
pv $FILENAME | mysql $DBNAME -u$DBUSER -p$DBPASS