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.
