Cacher is the code snippet organizer for pro developers

# Check the DB connection settings.
drush sql-connect

# Clear DB
drush sql-drop

# Бэкап всего.
drush arb --destination=backups/mysite.tar                               

#Бэкап базы
drush sql-dump --result-file=sites/default/files/prod-08.04.20.sql.gz --skip-tables-key=common --gzip 

#синхронизация баз по алиасам (drush sql-sync @bmi.dev @bmi.loc)
drush sql-sync @prod @dev --no-cache

#just simple create new db and import db from file
drush sql-create -y; 

# import db from file
drush sql-cli < dbdump.sql

#Create a db backup
drush sql-dump > ~/dbdump.sql

#DB import form the archive
sh -c "gunzip -c db/06.11.2018-10.24.26.sql.gz | drush @self sqlc"