Transfer your DB backups using ssh

This is an example on how you could script your database dumps to be copied to an external machine.

mysqldump -u MYSQL_USERNAME -pMYSQL_PASS | gzip -c | ssh -i /var/lib/jelastic/backup/somefolred/mykey.pub USERNAME@YOUR_TO_HOST 'cat > ~/dump.sql.gz'

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.