A MySQL easy-to-customize db mount script, with sensible defaults

mount_dump.sh

#!/bin/sh

DEFAULT_DB=marketplace_development
DEFAULT_DUMP=`ls -1t *.sql | head -1`

MYSQL_USER=root

# Easy overriding
export MYSQL_PWD=$MYSQL_PWD
export MYSQL_HOST=$MYSQL_HOST
export MYSQL_TCP_PORT=$MYSQL_TCP_PORT

mysql -u$MYSQL_USER -e 'show databases'

echo "What DB? (Ctrl+C to quit, Default: $DEFAULT_DB)"
read db
db=${db:-$DEFAULT_DB}

ls -l

echo "What dump? (Ctrl+C to quit, Default: $DEFAULT_DUMP)"
read dump
dump=${dump:-$DEFAULT_DUMP}

echo $db
echo $dump
echo $MYSQL_USER

mysqladmin -u$MYSQL_USER drop $db
mysqladmin -u$MYSQL_USER create $db
mysql -u$MYSQL_USER $db < $dump