1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#!/bin/sh
cd /bak/bakmysql
echo "You are in bakmysql directory"
mv bakmysql* /bak/bakmysqlold
echo "Old databases are moved to wditcast folder"
Now=$(date +"%d-%m-%Y")
File=bakmysql-wditcast-$Now.sql
mysqldump -uroot -p'abc123' --databases wditcast > $File
echo "Your database backup successfully completed"
SevenDays=$(date -d -7day  +"%d-%m-%Y")
if [ -f /bak/bakmysqlold/bakmysql-wditcast-$SevenDays.sql ]
then
rm -rf /bak/bakmysqlold/bakmysql-wditcast-$SevenDays.sql
echo "You have delete 7days ago bak file "
else
echo "7days ago bak file not exist "
fi

1
chmod 755 /opt/backup.sh

1
2
3
4
vi /etc/crontab
0 1 * * * root /opt/backup.sh

/sbin/service crond restart