/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