Create database from terminal mysql

python

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