Automatic Backup your dbhomewdb, uniquenamed, Logs, sql

[cystal]

1. create new folder scripts
create new sh file :
1.1 backupdb.sh

Spoiler

#!/bin/sh
date=`date +%d-%m-%Y-%T`;
/bin/mkdir -p  /root/backup/dbhomewdb/$date
echo "backup dbhomewdb $date/"
/bin/cp -rf /your/dbhomewdb/storage/folder/* /root/backup/dbhomewdb/$date/

1.2. backupuname.sh

Spoiler

#!/bin/sh
date=`date +%d-%m-%Y-%T`;
/bin/mkdir -p  /root/backup/uname/$date
echo "backup uniquenamed $date/"
/bin/cp -rf /your/uniquenamed/storage/folder/* /root/backup/uname/$date/

1.3. backuplogs.sh

Spoiler

#!/bin/sh
date=`date +%d-%m-%Y-%T`;
/bin/mkdir -p  /root/backup/logs/$date
echo "backup logs $date/"
/bin/cp -rf /your/logs/folder/* /root/backup/logs/$date/

1.4. backupsql.sh

Spoiler

#!/bin/sh
date=`date +%d-%m-%Y-%T`;
/bin/mkdir -p  /root/backup/sql/
mysqldump -u root -pYOURDBPASWORD YOURDBNAME > /root/backup/sql/zx_$date.sql

save those file in script folder
2. run command

Spoiler

chmod 775 -R /root/script

3. create new folder backup
4. create new file
backupdb

Spoiler

#! /bin/sh
cd /root/script/
./backupdb.sh
sleep 1
cd /root/script/
./backupuname.sh
sleep 1
cd /root/script/
./backuplogs.sh
sleep 1
echo "Backup mysql database..."
cd /root/script/
./backupsql.sh
sleep 1
exit 1

save in root folder
and dont forget to give permission for backupdb file
5. add new line on crontab for daily backup

Spoiler

0 0    * * *    root    /root/./backupdb