bash script create db subdir and backup to it

backup_db-prod.sh

#!/bin/bash

# create {year} folder if it doesn't exist
mkdir -p /home/web/db/$(date +%Y)

# dump database into {year} folder
mysqldump --opt -uweb -pPASSWORD DATABASE_NAME | gzip > /home/web/db/$(date +%Y)/DATABASE_NAME_$(date +%Y%m%d-%H%M).sql.gz