Database clear script - Remove database entirely, create new one and import from sql file, then run laravel migration and seed

clear-db.sh

## ===================================================================
## Database clear script
## Remove database entirely, create new one and import from sql file
## then run laravel migration and seed
## ===================================================================
# check if user passes two parameters
if [ $# -ne 3 ]; then
    echo "Usage: $0 <db-name> <sql-file> <db-password>"
    exit 1
fi

# delete db
mysql -u root -p$3 -e "DROP DATABASE IF EXISTS $1"

# create db
mysql -u root -p$3 -e "CREATE DATABASE $1"

# import from sql
mysql -u root -p$3 $1 < $2

# run migration
php artisan migrate

# run seed
php artisan db:seed