Mysql database backup script
#! / 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=$Date.sql
BZDumpFile=$Date.sql.tar.bz2
/ usr/bin/mysqldump-u database login account-p database password-- all-databases > $DumpFile
/ bin/tar jvcf $BZDumpFile $DumpFile
/ bin/rm $DumpFile
Openssl enc-k backup encrypted password-aes-128-ecb-e-in $BZDumpFile- out $BZDumpFile-aes
#-d decryption
/ bin/rm $BZDumpFile
Last=date + "Y% m / d% H:%M:%S"
Echo "" > > $LogFile
Echo "- fullybak-" > > $LogFile
Echo "$BZDumpFile-aes copying" > > $LogFile
Echo start: $Begin end: $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 "" > > $LogFile
Echo "- scp-" > > $LogFile
If (test-e $Date.sql.tar.bz2-aes)
Then
Scp $BakDir/$Date.sql.tar.bz2-aes backup@10.0.0.22:/home/backup/backup55
If ["$?" = "0"]
Then
Echo "$Date.sql.tar.bz2-aes sending..." > > $LogFile
Else
Echo "scp failed..." > > $LogFile
Fi
Else
Echo "$Date.sql.tar.bz2-aes not exist!" > > $LogFile
Fi
If (test-e $Date.tar.bz2-aes)
Then
Scp $BakDir/$Date.tar.bz2-aes backup@10.0.0.22:/home/backup/backup55
If ["$?" = "0"]
Then
Echo "$Date.tar.bz2-aes sending..." > > $LogFile
Else
Echo "scp failed..." > > $LogFile
Fi
Else
Echo "$Date.tar.bz2-aes not exist!" > > $LogFile
Fi
Last=date + "Y% m / d% H:%M:%S"
Echo start: $Begin end: $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 "" > > $LogFile
Echo "- rm-" > > $LogFile
If (test-e $GZDumpFile)
Then
If (test-e $oldBakDir0)
Then
Rm-rf $oldBakDir0
Echo "delete increased sql $oldBakDir0" > > $LogFile
Else
Echo "$oldBakDir0 not exist!" > > $LogFile
Fi
If (test-e $oldBakDir1) then rm-rf $oldBakDir1 echo "delete increased sql $oldBakDir1" > > $LogFileelse echo "$oldBakDir1 not exist!" > > $LogFilefiif (test-e $oldBakDir2) then rm-rf $oldBakDir2 echo "delete increased sql $oldBakDir2" > > $LogFileelse echo "$oldBakDir2 not exist!" > $LogFilefiif (test-e $oldBakDir3) then rm-rf $oldBakDir3 echo "delete increased sql $oldBakDir3" > > $LogFileelse echo "$oldBakDir3 not exist!" > > $LogFilefiif (test-e $oldBakDir4) then rm-rf $oldBakDir4 echo "oldBakDir4 echo $delete increased sql" > > $delete increased sql Echo "$oldBakDir4 not exist!" > > $LogFilefiif (test-e $oldBakDir5) then rm-rf $oldBakDir5 echo "delete increased sql $oldBakDir5" > > $LogFileelse echo "$oldBakDir5 not exist!" > > $LogFilefiif (test-e $oldBakDir6) then rm-rf $oldBakDir6 echo "delete increased sql $oldBakDir6" > > $LogFileelse echo "$oldBakDir6 not exist!" > $LogFilefiif (test-e $oldBakFile) then rm-rf $oldBakFile echo "delete full sql $oldBakFile" > $LogFileelse echo "$oldBakFile not exist!" > $LogFilefi
Else
Echo "Warning:There is no backup todaylights!" > > $LogFile
Fi
Last=date + "Y% m / d% H:%M:%S"
Echo start: $Begin end: $Last succ > > $LogFile
0 230 / 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/mysqlbackup/data" / lvshandata +% Y_%m_%d.zip
/ usr/bin/mysqldump-- opt-u$username-p$password-hlocalhost lvshan > $mysql_data
/ bin/zip $mysql_zip $mysql_data
/ bin/rm $mysql_data
Openssl enc-k backup encrypted password-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
