this shell script will take an .sql backup file and install it to a given database. it will prompt you for username, password, database, and sql file. i set my default file location to ~/Downloads/ because that's where i always have my backups. edit as necessary.

dbbackup.sh

#!/bin/sh
echo -e "\e[01;33m[username]\e[00m"
read user
echo -e "\e[01;33m[password]\e[00m"
read pass
echo -e "\e[01;33m[database]\e[00m"
read db
echo -e "\e[01;33m[sql file]\e[00m"
read file
mysql> mysql -u $user -p $pass $db < ~/Downloads/$file