FROM_DB_HOSTNAME=
FROM_DB_DATABASE=
FROM_DB_USERNAME=
FROM_DB_PASSWORD=

TO_DB_HOSTNAME=
TO_DB_USERNAME=
TO_DB_PASSWORD=

echo [`date +%H:%M:%S`] Backup started...
mkdir -p data
filename=data/$FROM_DB_DATABASE-`date +%Y-%m-%d_%H:%M:%S`.sql
mysqldump -h $FROM_DB_HOSTNAME -u $FROM_DB_USERNAME --databases $FROM_DB_DATABASE --password=$FROM_DB_PASSWORD > $filename
bzip2 $filename
echo [`date +%H:%M:%S`] Backup finished.

echo [`date +%H:%M:%S`] Import started...
filename=data/`ls -Art data/ | tail -n 1`
echo -n Loading $filename ...
cat $filename | bzip2 -d | mysql -h $TO_DB_HOSTNAME -u $TO_DB_USERNAME --password=$TO_DB_PASSWORD
retval=$?
if [ $retval==0 ]; then
	echo done
else
	echo failed with $retval.
fi

echo [`date +%H:%M:%S`] Import finished.