Run script backup data in Mysql

DB_NAME="eccubedev"
DB_USER="root"
DB_PASS="your_password"
BACKUP_DIR="$HOME/backupDB/BackupFiles"
DATE=$(date +"%Y%m%d_%H%M%S")
BACKUP_FILE="$BACKUP_DIR/${DB_NAME}_backup_$DATE.sql"
TOTAL_BACKUP_FILES=100

# Create backup directory if it doesn't exist
mkdir -p $BACKUP_DIR

# Dump the database
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_FILE

# Delete oldest backups, keeping only the most recent $TOTAL_BACKUP_FILES
cd $BACKUP_DIR
NUM_FILES=$(ls -1 | wc -l)
if [ $NUM_FILES -gt $TOTAL_BACKUP_FILES ]; then
    DELETE_FILES=$(expr $NUM_FILES - $TOTAL_BACKUP_FILES)
    ls -t | tail -n $DELETE_FILES | xargs rm -f
fi

Thank you