mysql_test_import.sh

#!/bin/bash

# stop on errors
set -e
# turn on debugging
set -x

mysql -e "DROP DATABASE IF EXISTS \`test_import\`; CREATE DATABASE IF NOT EXISTS \`test_import\` DEFAULT CHARACTER SET utf8;"
START_TIME=$(date -u +"%s")

# 2 minutes
#vagrant ssh db -- 'mysql -uroot --password="" -D test_import --default-character-set=utf8 < /server/.shared/magento-database.sql'
#vagrant ssh db -- 'pv /server/.shared/magento-database.sql | mysql -uroot --password="" -D test_import --default-character-set=utf8'

# ? min
#vagrant ssh web -- 'mysql -D test_import --default-character-set=utf8 < /sites/m2esedev.dev/magento-database.sql'

# 27 minutes
#mysql -D test_import --default-character-set=utf8 < /sites/m2esedev.dev/magento-database.sql
#pv /sites/m2esedev.dev/magento-database.sql | mysql -D test_import --default-character-set=utf8

# 2 min
pv /sites/m2esedev.dev/magento-database.sql | ssh dev-db 'mysql -uroot --password="" -D test_import --default-character-set=utf8'

END_TIME=$(date -u +"%s")
TIME_DIFF=$(($END_TIME-$START_TIME))
echo "$(($TIME_DIFF / 60)) minutes and $(($TIME_DIFF % 60)) seconds elapsed."