backup_daily.sh

#!/bin/bash  

#filename backup 
fileName= db_retail_bck_$(date +%Y%m%d).log 
path='/home/user/backup' 
fullPath=${path}/${fileName}

echo ${fileName} 
echo ${path}  
echo ${fullPath}

#dobackup 
if ! test -f ${fullPath}; then
	mysqldump --no-tablespaces -u retail2 -p'Retail@--20@' db_toko >  ${fullPath}
fi

#if exist and backup success delete file older than 7 days
if test -f ${fullPath}; then 
	find ${path} ! -type d -mtime +7 -name 'db_retail_bck_*.sql' -delete
fi