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)
sggoyal