- Joined
- Oct 27, 2012
- Messages
- 112
- Reaction score
- 12
1. create new folder scripts
create new sh file :
1.1 backupdb.sh
1.2. backupuname.sh
1.3. backuplogs.sh
1.4. backupsql.sh
save those file in script folder
2. run command
3. create new folder backup
4. create new file
backupdb
save in root folder
and dont forget to give permission for backupdb file
5. add new line on crontab for daily backup
create new sh file :
1.1 backupdb.sh
Code:
#!/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/
Code:
#!/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/
Code:
#!/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/
Code:
#!/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
2. run command
Code:
chmod 775 -R /root/script
4. create new file
backupdb
Code:
#! /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
and dont forget to give permission for backupdb file
5. add new line on crontab for daily backup
Code:
0 0 * * * root /root/./backupdb
Last edited: