Nov 19th, 2012
#backup DATEVAR=`date +%Y-%m-%d--%H-%M-%S`; mysqldump -u[username] -p[password] [database_name] > backup_$DATEVAR.sql; #restore mysql -u[username] -p[password] [database_name] < backup_$DATEVAR.sql; ## In one command, dump the remote into local ## ssh -C username@mysite.com mysqldump -u[remote user] -p[remote pass] [remote db] | mysql -u[local user] -p[local pass] [local db]