pulling database in local via ssh

reply_database_in_local.sh

#!/bin/bash

# SSH
ID_RSA=~/.ssh/id_rsa
USER=root
DOMAIN=my-domain.com

# Remote mysql
REMOTE_DB_USER=root
REMOTE_DB_PASS=database-password
REMOTE_DB_NAME=database-name

# Local mysql
LOCAL_DB_USER=root
LOCAL_DB_PASS=secret
LOCAL_DB_DATABASE=local_database

NOW=$(date +"%Y%m%d-%H%M")
SCRIPT_NAME=remote-$NOW.sql
eval "ssh -i $ID_RSA $USER@$DOMAIN 'mysqldump -u $REMOTE_DB_USER -p$REMOTE_DB_PASS $REMOTE_DB_NAME' > $SCRIPT_NAME"
echo "Base de datos importada en archivo $SCRIPT_NAME!"
echo "Importando Base de datos..."
eval "mysql -u$LOCAL_DB_USER -p$LOCAL_DB_PASS $LOCAL_DB_DATABASE < $SCRIPT_NAME"
echo "Base de datos importada"
eval "rm $SCRIPT_NAME"
echo "Finalizado!"