DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Mysql Dump To Another Server
// 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 firstname.lastname@example.org "dd of=/mysql/$(date +'%d-%m-%y')"