#!/bin/sh
echo "* rm -f /tmp/kameleoon.sql.bz2 /tmp/kameleoon.sql"
rm -f /tmp/kameleoon.sql.bz2 /tmp/kameleoon.sql
echo "* mysqladmin -ukameleoon -pkameleoon_dev -f drop net_kameleoon-dev_kameleoon"
mysqladmin -ukameleoon -pkameleoon_dev -f drop net_kameleoon-dev_kameleoon
echo "* mysqladmin -ukameleoon -pkameleoon_dev create net_kameleoon-dev_kameleoon"
mysqladmin -ukameleoon -pkameleoon_dev create net_kameleoon-dev_kameleoon
echo "* scp root@gondolin.kameleoon.net:/srv/net.kameleoon/backup/$1/kameleoon.sql.bz2 /tmp/"
scp root@angband.kameleoon.net:/srv/net.kameleoon/backup/$1/kameleoon.sql.bz2 /tmp/
echo "* bunzip2 /tmp/kameleoon.sql.bz2"
bunzip2 /tmp/kameleoon.sql.bz2
echo "* sed -i 's/com_kameleoon_kameleoon/net_kameleoon-dev_kameleoon/g' /tmp/kameleoon.sql"
sed -i 's/com_kameleoon_kameleoon/net_kameleoon-dev_kameleoon/g' /tmp/kameleoon.sql
echo "* mysql -ukameleoon -pkameleoon_dev net_kameleoon-dev_kameleoon < /tmp/kameleoon.sql"
mysql -ukameleoon -pkameleoon_dev net_kameleoon-dev_kameleoon < /tmp/kameleoon.sql