Rehat一鍵安裝mysql指令碼和備份資料庫指令碼

標籤：file   技術分享   資料   .com   community   ash   ges   服務   alt   

Rehat一鍵安裝mysql指令碼

##說明：適用，Rehat 5 6 7

1.運行狀態，運行成功輸出mysql臨時密碼

 

2.代碼如下

#!/bin/bash  #擷取系統資訊sudo cat /etc/issue>myfileaa=sudo grep ‘5.‘ myfilebb=sudo grep ‘6.‘ myfilecc=sudo grep ‘7.‘ myfileecho $aaecho "It is a test" > myfile#擷取系統資訊sudo cat /etc/issue>myfileaa=sudo grep ‘5.‘ myfilebb=sudo grep ‘6.‘ myfilecc=sudo grep ‘7.‘ myfileecho $aaecho $ccecho $bb#配置yum源if [ "$aa"x != "‘‘"x ]then  echo "您的系統是rehat5的版本，即將為您安裝mysql"  wget https://repo.mysql.com//mysql57-community-release-el5-8.noarch.rpm --no-check-certificate  rpm -Uvh mysql57-community-release-el5-8.noarch.rpmelif [ "$bb"x != "‘‘"x ]then  echo "您的系統是rehat6的版本，即將為您安裝mysql"  wget https://repo.mysql.com//mysql57-community-release-el6-10.noarch.rpm --no-check-certificate  rpm -Uvh mysql57-community-release-el6-10.noarch.rpmelif [ "$cc"x != "‘‘"x ]then  echo "您的系統是rehat7的版本，即將為您安裝mysql"  wget https://repo.mysql.com//mysql57-community-release-el7-10.noarch.rpm --no-check-certificate  rpm -Uvh mysql57-community-release-el7-10.noarch.rpmfi#安裝系統yum install mysql-community-server#啟動服務service mysqld start#查看臨時密碼檔案grep ‘temporary password‘ /var/log/mysqld.log

 

Rehat備份mysql指令碼

1.代碼如下：

#!/bin/bash    #儲存備份個數  number=3  #備份儲存路徑  backup_dir=/root/mysqlbackup  #日期  dd=`date +%Y%m%d`  #備份工具  tool=mysqldump  #使用者名稱  username=root  #密碼  password=******  #將要備份的資料庫  database_name=users    #簡單寫法  mysqldump -u root -p123456 users > /root/mysqlbackup/users-$filename.dump  $tool -u $username -p$password $database_name > $backup_dir/$database_name-$dd.dump    #寫建立備份日誌  echo "create $backup_dir/$database_name-$dd.dupm" >> $backup_dir/log.txt    #找出需要刪除的備份  delfile=`ls -l -crt  $backup_dir/*.dump | awk ‘{print $9 }‘ | head -1`    #判斷現在的備份數量是否大於$number  count=`ls -l -crt  $backup_dir/*.dupm | awk ‘{print $9 }‘ | wc -l`    if [ $count -gt $number ]  then    rm $delfile  #刪除最早產生的備份，只保留number數量的備份    #寫刪除檔案日誌    echo "delete $delfile" >> $backup_dir/log.txt  fi  

 

Rehat一鍵安裝mysql指令碼和備份資料庫指令碼