備份數據庫的shell腳本一
代碼如下:
#!/bin/bash
#指定運行的腳本shell
#運行腳本要給用戶執行權限
bakdir=/backup
month=`date +%m`
day=`date +%d`
year=`date +%Y`
hour=`date +%k`
min=`date +%M`
dirname=$year-$month-$day-$hour-$min
mkdir $bakdir/$dirname
mkdir $bakdir/$dirname/conf
mkdir $bakdir/$dirname/web
mkdir $bakdir/$dirname/db
#熱備份數據庫
cp /opt/mysql/my.cnf $bakdir/$dirname/db/my.cnf
cd /opt/mysql
mysqldump --opt -u zhy -p --password=1986 test>$bakdir/$dirname/db/test.sql
mysqldump --opt -u zhy -p --password=1986 phpwind>$bakdir/$dirname/db/phpwind.sql
#遠程拷貝的目錄要有可寫權限
scp -r /backup/$dirname root@10.1.1.178:/backup

數據庫備份腳本shell二
代碼如下:
[plain]
#!/bin/bash   
#---------------------------- 
#Target machine configuration 
#---------------------------- 
#DBUser->Database user name 
#DBPasswd->Database password ,not null 
#DBName->Database name 
#SERVER->IP address 
#---------------------------- 
DBUser=**** 
DBPasswd=**** 
DBName=***** 
SERVER=**** 

#-------------------------------- 
#The local machine configuration 
#-------------------------------- 
#LocalDBUser->Database user name 
#LocalDBPasswd->Database password,not null 
#LocalDBName->Database name 
#BackupPath->Backup path,end with '/' 
#LogFile->Log file 
#num->backup numbers 
#-------------------------------- 
LocalDBUser=** 
LocalDBPasswd=*** 
LocalDBName=**** 
BackupPath=**** 
LogFile=**** 
#num=2 -----> Has not been completed 
#------------------------------- 

#------------------------------- 
#Other configuration 
#------------------------------- 
#IgnoreTables->ignore tables,like this: 
#IgnoreTables= '--ignore-table=DBName.TableName1 --ignore-table=DBName.TableName2 .....' 
#NeedTables->need backup tables,if you want to backup all tables,please let it empty 
#like this: NeedTables='table1 table2 table3' 
#------------------------------- 
IgnoreTables='****‘  
NeedTables= 
#begin 

NewFile="$BackupPath"dbBackup$(date +%y%m%d).sql   
OldFile="$BackupPath"dbBackup$(date +%y%m%d --date='5 days ago').sql  

echo "-------------------------------------------" >> $LogFile   
echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile   
echo $(date +%y%m%d --date='5 days ago') >>$LogFile 
echo "--------------------------" >> $LogFile   
#Delete Old File 
if [ -f $OldFile ]   
then   
   rm -f $OldFile >> $LogFile 2>&1