/bin/bash

TIMESTAMP=/bin/date +%Y-%m-%d--%H-%M DESTINATION='/home/ubuntu/BACKUP'

mysqldump -hlocalhost -uroot -pPASSWORD --opt --all-databases > $DESTINATION/$TIMESTAMP.sql tar -czvf $DESTINATION/$TIMESTAMP.sql.tar.gz $DESTINATION/$TIMESTAMP.sql rm $DESTINATION/$TIMESTAMP.sql