Create a script file :-  /usr/local/sbin/mysqlbackup.sh

Add below code :-

#!/bin/sh

# Current date
datum=`/bin/date +%Y%m%d-%H`

/usr/bin/mysqldump –user=root –password=RootPassword  \
      Database_name | gzip -9 > /home/sqlbackup/${filename}-${datum}.sql.gz
for file in “$( /usr/bin/find /home/sqlbackup -type f -mtime +5 )”
do
  /bin/rm -f $file
done

exit 0

crontab -e

Add Below Line :-

0 0 * * * /usr/local/sbin/mysqlbackup.sh &> /dev/null ( For Backup Daily)