ssh root@138.197.183.30 'mysqldump -uipsremont -p9WazVrptkuWj3gs2 ipsremont | gzip > /var/www/ipsremont/dump.sql.gz' say "Dump creation complete, please enter you ssh password." scp root@138.197.183.30:/var/www/ipsremont/dump.sql.gz dump.sql.gz say "Downloading complete, start restoring." gunzip < dump.sql.gz | mysql -uroot -proot -h 127.0.0.1 -P8989 ipsremont say "Dump restore complete, your Majesty."