shell script to take frequently back of mysql DB ignoring cache tables using drush

MysqlBackupDrush.sh

#!/bin/bash
        DATE=$(date +%d-%m-%Y)
        BACKUP_DIR="BACKUP DIRECTORY LOCATION"
        SITENAME="YOUR SITE NAME"
        DIR="PATH TO DRUPAL INSTALLATION"
        mkdir -p $BACKUP_DIR/$DATE
        cd $DIR && drush sql-dump --extra=--no-data > $BACKUP_DIR/$DATE/$SITENAME-$DATE.sql
        cd $DIR && drush sql-dump --skip-tables-list=cache,cache_* >> $BACKUP_DIR/$DATE/$SITENAME-$DATE.sql
        gzip $BACKUP_DIR/$DATE/$SITENAME-$DATE.sql
        
        # remove backup older than 4 days
        find $BACKUP_DIR/* -mtime +4 -exec rm -rf {} \;