Quickly drop, create and import MySQL database with Drush in Drupal

MySQL

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