Script to generate automatic database backup from MySQL databse

Generate automatic database backup

1. Create a file generatedbbackup.sh in your /home/dbback/

2. Copy the below code to generatedbbackup.sh

#!/bin/bash
rm -rf /home/dbback/day7/*
mv /home/dbback/day6/*  /home/dbback/day7/
mv /home/dbback/day5/*  /home/dbback/day6/
mv /home/dbback/day4/*  /home/dbback/day5/
mv /home/dbback/day3/*  /home/dbback/day4/
mv /home/dbback/day2/*  /home/dbback/day3/
mv /home/dbback/day1/*  /home/dbback/day2/

mysqldump -u [user_name] -p[password] --routines [database_name1] | /bin/gzip >  /home/dbback/day1/[database_name1].sql.gz
mysqldump -u [user_name] -p[password] --routines [database_name2] | /bin/gzip >  /home/dbback/day1/[database_name2].sql.gz

3. Give Execute permission for the script generatedbbackup.sh

4.Create directory dbback in your home directory

5. Create directories day1,day2,day3....day7 in daback folder

6.Set the script in your cronejob.

Your last 7 days database backup will we there in your server.