#!/bin/bash

Begin=date +"%Y年%m月%d日 %H:%M:%S"
BakDir=/home/backup/backup
LogFile=/home/backup/backup/bak.log
Date=date +%Y%m%d

cd $BakDir

DumpFile= D a t e . s q l B Z D u m p F i l e = Date.sql BZDumpFile= Date.sqlBZDumpFile=Date.sql.tar.bz2
/usr/bin/mysqldump -u数据库登录帐号 -p数据库密码 --all-databases > $DumpFile
/bin/tar jvcf $BZDumpFile $DumpFile
/bin/rm $DumpFile

openssl enc -k 备份加密密码 -aes-128-ecb -e -in $BZDumpFile -out $BZDumpFile-aes
#-d 解密
/bin/rm $BZDumpFile

Last=date +"%Y年%m月%d日 %H:%M:%S"
echo “”>> L o g F i l e e c h o " − − − − − − − − − f u l l y b a k − − − − − − − − " > > LogFile echo "---------fullybak--------">> LogFileecho"−−−−−−−−−fullybak−−−−−−−−">>LogFile
echo " B Z D u m p F i l e − a e s c o p y i n g " > > BZDumpFile-aes copying">> BZDumpFile−aescopying">>LogFile
echo 开始: B e g i n 结束 : Begin 结束: Begin结束:Last $BZDumpFile-aes succ >> $LogFile

#!/bin/bash

Begin=date +"%Y年%m月%d日 %H:%M:%S"

BakDir=/home/backup/backup
LogFile=/home/backup/backup/bak.log
Date=date +%Y%m%d

cd $BakDir

echo “”>> L o g F i l e e c h o " − − − − − − − − − s c p − − − − − − − − " > > LogFile echo "---------scp--------">> LogFileecho"−−−−−−−−−scp−−−−−−−−">>LogFile

if (test -e $Date.sql.tar.bz2-aes)
then
scp B a k D i r / BakDir/ BakDir/Date.sql.tar.bz2-aes  backup@10.0.0.22:/home/backup/backup55
if [ “ ? " = " 0 " ] t h e n e c h o " ?" = "0" ] then echo " ?"="0"]thenecho"Date.sql.tar.bz2-aes sending…”>> L o g F i l e e l s e e c h o " s c p f a i l e d . . . " > > LogFile else echo "scp failed...">> LogFileelseecho"scpfailed...">>LogFile
fi
else
echo " D a t e . s q l . t a r . b z 2 − a e s n o t e x i s t ! " > > Date.sql.tar.bz2-aes not exist!">> Date.sql.tar.bz2−aesnotexist!">>LogFile
fi

if (test -e $Date.tar.bz2-aes)
then
scp B a k D i r / BakDir/ BakDir/Date.tar.bz2-aes  backup@10.0.0.22:/home/backup/backup55
if [ “ ? " = " 0 " ] t h e n e c h o " ?" = "0" ] then echo " ?"="0"]thenecho"Date.tar.bz2-aes sending…”>> L o g F i l e e l s e e c h o " s c p f a i l e d . . . " > > LogFile else echo "scp failed...">> LogFileelseecho"scpfailed...">>LogFile
fi
else
echo " D a t e . t a r . b z 2 − a e s n o t e x i s t ! " > > Date.tar.bz2-aes not exist!">> Date.tar.bz2−aesnotexist!">>LogFile
fi

Last=date +"%Y年%m月%d日 %H:%M:%S"

echo 开始: B e g i n 结束 : Begin 结束: Begin结束:Last succ >> $LogFile

#!/bin/bash

Begin=date +"%Y年%m月%d日 %H:%M:%S"
LogFile=/home/backup/backup/bak.log
BakDir=/home/backup/backup
cd $BakDir
oldBakDir0=date -d '-35 days' +%Y%m%d.tar.bz2-aes
oldBakDir1=date -d '-34 days' +%Y%m%d.tar.bz2-aes
oldBakDir2=date -d '-33 days' +%Y%m%d.tar.bz2-aes
oldBakDir3=date -d '-32 days' +%Y%m%d.tar.bz2-aes
oldBakDir4=date -d '-31 days' +%Y%m%d.tar.bz2-aes
oldBakDir5=date -d '-30 days' +%Y%m%d.tar.bz2-aes
oldBakDir6=date -d '-29 days' +%Y%m%d.tar.bz2-aes
oldBakFile=date -d '-35 days' +%Y%m%d.sql.tar.bz2-aes

Date=date +%Y%m%d
GZDumpFile=$Date.sql.tar.bz2-aes

echo “”>> L o g F i l e e c h o " − − − − − − − − − r m − − − − − − − − " > > LogFile echo "---------rm--------">> LogFileecho"−−−−−−−−−rm−−−−−−−−">>LogFile
if (test -e $GZDumpFile)
then
if (test -e $oldBakDir0)
then
rm -rf $oldBakDir0
echo “delete increased sql $oldBakDir0” >> L o g F i l e e l s e e c h o " LogFile else echo " LogFileelseecho"oldBakDir0 not exist!" >> $LogFile
fi

if (test -e $oldBakDir1)
then
	rm -rf $oldBakDir1
	echo "delete increased sql $oldBakDir1" >> $LogFile
else
	echo "$oldBakDir1 not exist!" >> $LogFile
fi

if (test -e $oldBakDir2)
then
	rm -rf $oldBakDir2
	echo "delete increased sql $oldBakDir2" >> $LogFile
else
	echo "$oldBakDir2 not exist!" >> $LogFile
fi

if (test -e $oldBakDir3)
then
	rm -rf $oldBakDir3
	echo "delete increased sql $oldBakDir3" >> $LogFile
else
	echo "$oldBakDir3 not exist!" >> $LogFile
fi

if (test -e $oldBakDir4)
then
	rm -rf $oldBakDir4
	echo "delete increased sql $oldBakDir4" >> $LogFile
else
	echo "$oldBakDir4 not exist!" >> $LogFile
fi

if (test -e $oldBakDir5)
then
	rm -rf $oldBakDir5
	echo "delete increased sql $oldBakDir5" >> $LogFile
else
	echo "$oldBakDir5 not exist!" >> $LogFile
fi

if (test -e $oldBakDir6)
then
	rm -rf $oldBakDir6
	echo "delete increased sql $oldBakDir6" >> $LogFile
else
	echo "$oldBakDir6 not exist!" >> $LogFile
fi

if (test -e $oldBakFile)
then
	rm -rf $oldBakFile
	echo "delete full sql $oldBakFile" >> $LogFile
else
	echo "$oldBakFile not exist!" >> $LogFile
fi

else
echo “Warning:There is no backup today!!” >> $LogFile
fi

Last=date +"%Y年%m月%d日 %H:%M:%S"
echo 开始: B e g i n 结束 : Begin 结束: Begin结束:Last succ >> $LogFile

0 23 * * 0 /bin/sh /home/backup/Mysql-FullyBak.sh > /home/backup/cronlog.txt 2>&1
45 23 * * 0 /bin/sh /home/backup/rmBak.sh > /home/backup/cronlog.txt 2>&1
30 23 * * * /bin/sh /home/backup/scpBak.sh > /home/backup/cronlog.txt 2>&1

#! /bin/bash

username=root
ps=‘TH’
mysql_data=“/home/mysql_backup/data”/lvshan.sql
password=echo $ps|base64 -d
mysql_zip=“/home/mysql_backup/data”/lvshan_zip.zip
mysql_back=“/home/mysql_backup/data”/lvshan_data +%Y_%m_%d.zip

/usr/bin/mysqldump --opt -u u s e r n a m e − p username -p username−ppassword -hlocalhost lvshan > $mysql_data
/bin/zip $mysql_zip $mysql_data
/bin/rm $mysql_data

openssl enc -k 备份加密密码 -aes-128-ecb -e -in $mysql_zip -out $mysql_back
/bin/rm $mysql_zip

scp -P 6008 $mysql_back root@ip:/home/mysql_backup_lvshan_ip