Quickly drop, create and import MySQL database with Drush in Drupal
19 April, 2018 - 11:20

Create, drop and import a MySQL database using Drush for Drupal:
# Drop, create and import database, assumes database located one level up
drush sql-query "drop database DB_NAME_NEW;"
drush sql-query "create database DB_NAME_NEW;"
mysql -u root -proot DB_NAME_NEW < ../DB_NAME.sql