Create database from terminal mysql

create database from terminal mysql

              
                DATE=`date +%Y_%m_%d`
mysql -u root -p -e "drop database DATABASE_NAME;create database DATABASE_NAME;"
mysql -u root -p DATABASE_NAME < PATH_TO_MYSQL_DUMP_FILE.sql