MySQL backup and restore

#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]