# # From: http://www.cyberciti.biz/tips/category/mysql # mysqldump -u USERNAME -p'PASSWORD' YOUR-DATABASE-NAME | ssh user@remote.server.com "dd of=/mysql/$(date +'%d-%m-%y')" mysqldump -u USERNAME -p'PASSWORD' YOUR-DATABASE-NAME | "dd of=/mysql/$(date +'%d-%m-%y')"