Дамп базы данных с удаленного сервера на Localhost

.sh - Remote mysqldump db to the localhost

#!/bin/sh
# 1. https://gist.github.com/zetrider/28f1d463c6bd9af1c0e6
# 2. $1 = type !important

if [ -z $1 ]; then
	echo 'Not found the first variable "Type"'
	exit;
fi;

### Site1 ###
if [ $1 = 'S1' ]; then

	HOST='user@server.ru'
	DB_USER='user'
	DB_PASS='password'
	DB_NAME='base'
	DB_LOCAL='base_local';
	DUMP_NAME=$DB_NAME'_'`date +%Y_%m_%d`'.sql'

	echo 'Connect to the: '$HOST
	echo 'Download database: '$DB_NAME
	ssh $HOST mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $DUMP_NAME
	echo 'The file was created: '$DUMP_NAME

fi

### Copy to the Localhost ###
if [ -s $DUMP_NAME ]; then
	echo 'Import to the: Localhost'
	# Your mysql
	/Applications/MAMP/Library/bin/mysql -u root -proot $DB_LOCAL < $DUMP_NAME
	echo 'Completed the import into the: Localhost'
	rm $DUMP_NAME;
else
	echo 'Error: File is not exist'
fi;