// Using UNIX pipe concept one can dump database to another server securely using ssh protocol. // All you need remote execution rights for the ‘dd’ command, over SSH. mysqldump -u USERnAME -p'PASSWORD' YOUR-DATABASE-NAME | ssh user@remote.server.com "dd of=/mysql/$(date +'%d-%m-%y')"
