import-mysql

#!/bin/sh
exit=1
getout=0
if [ "$1" = "" ];
then
	echo "You must suply filename to import"
	getout=1
else
	file=$1
fi

if [ "$2" = "" ];
then
	echo "You must suply  username of your mysql"
	getout=1
fi

if [ "$3" = "" ];
then
	echo "You must suply your destination database"
	getout=1
fi

if [ "$getout" -eq "$exit" ]
then
	echo "usage = pv FILENAME | mysql -u USERNAME -p DATABASE"
	exit
else
	if [ "${file##*.}" = "sql" ]
	then
		pv $1 | mysql -u $2 -p $3
	else
		echo "You must specified sql file"
		echo "${file##*.}"
		exit
	fi
fi