How to automatically back up the MySQL database every day on Ubuntu?

bash

vim ~/mysql_backup.sh

sudo chmod 777 ~/mysql_backup.sh
sudo ~/mysql_backup.sh

crontab -e

mysql_backup.sh

#!/bin/bash
SQL_USERNAME=test
SQL_PASSWORD=test
SQL_DBNAME=test
FILE_NAME=`date +"%Y%m%d%H%M%S"`
BACKUP_DIR=/home/ubuntu/backup/

mysqldump -u$SQL_USERNAME -p$SQL_PASSWORD --databases $SQL_DBNAME > $BACKUP_DIR$FILE_NAME.sql

tar -cvzf $BACKUP_DIR${FILE_NAME}.tar.gz $BACKUP_DIR${FILE_NAME}.sql
rm -rf $BACKUP_DIR${FILE_NAME}.sql

find $BACKUP_DIR -type f -name '*.tar.gz' -mtime +30 -exec rm {} \;

crontab

0 0 * * * ~/mysql_backup.sh >/dev/null 2>&1