Create Auto Backup Database on Linux

apt-get install cron

crontab -e

#!/bin/sh

 mysqldump -u root -pQidDniuJMb@LC@G5 gift > /var/bin/db/gift/gift.sql

 cd /var/bin/db/gift/

 tar -zcvf giftsql_$(date +%d%m%y).tgz *.sql

 find -name '*.tgz' -type f -mtime +2 -exec rm -f {} \;

0 * * * * /var/bin/mysqlbackup.sh

*/3 * * * * /var/bin/executedb.sh