Database Sync

gistfile1.txt

HTTPAUTH_USER='root'
HTTPAUTH_PASS='root'
HTTPD_DUMP_URL=
wget --user={$HTTPAUTH_USER} --password={$HTTPAUTH_PASS} -O /tmp/dump.sql.gz {$HTTPD_DUMP_URL}/latest.sql.gz

mysql -uroot -proot --silent --skip-column-names -e "SHOW TABLES" staging | xargs -L1 -I% echo 'DROP TABLE `%`;' | sudo mysql -uroot -proot -v staging
gunzip /tmp/dump.sql.gz 
sudo mysql -u root staging < /tmp/dump.sql -v
sudo rm /tmp/dump.sql 
# sudo rm /tmp/dump.sql.gz
cd /var/www/staging/
drush cr
drush cim