shll脚本应用示例

朴灿烈づ我的快乐病毒、 2022-01-11 09:31 256阅读 0赞

## 1.数据库备份 ##

执行 db\_dump.sh westos( 数据库密码 )

要求：脚本执行后会备份数据库中的所有库到 /mnt/mysqldump 目录中；备份文件名称为 “库名称 .sql” 当此文件存在时报错并询问动作，输入“ S” 跳过备份,当输入“ B" 时备份“库名称 .sql” 文件为“库名称 \_backup.sql”, 当输入“ O” 时,覆盖源文件。

#!/bin/bash
    if [ ! -e "/var/lib/mysql/mysql.sock" ]
    then
             echo "Error: Mysql is not running"
             exit 1
    elif [ -z "$1" ]
    then
             echo "Error: Please show db password following $0"
             exit 1
    fi
    mysql -uroot -p$1 -e "show databases;" &> /dev/null
    if [ "$?" -ne "0" ]
    then
            echo "Error: Wrong password for db!!"
            exit 1
    fi
    [ -e "/mnt/mysqldump" ]||{
            mkdir -p /mnt/mysqldump
    }
    All_DB=`mysql -uroot -pwestos  -NE  -e  "SHOW DATABASES;" | sed '/^*/d;/schema$/d'`
     
    Action_Choose()
    {
                    read -p "Please input your action: " ACTION
                    case $ACTION in
                            S|s|Skip|skip)
                            ;;
                            B|b|Backup|backup)
                            mv /mnt/mysqldump/${DBNAME}.sql /mnt/mysqldump/${DBNAME}_backup.sql
                            mysqldump -uroot -p$1 $DBNAME > /mnt/mysqldump/${DBNAME}.sql
                            ;;
                            O|o|overwrite|Overwrite)
                            mysqldump -uroot -p$1 $DBNAME > /mnt/mysqldump/${DBNAME}.sql
                            ;;
                            *)
                            echo "Error: Wrong action please input s|o|b|"
                            Action_Choose
                    esac
    
    }
    
    for DBNAME in $All_DB
    do
            if [ -e "/mnt/mysqldump/${DBNAME}.sql" ]
            then
                   echo "$DBNAME's backupfile is exist!!"
                    echo "You can choose your action"
                    echo "[S]kip [B]ackup [O]verwrite"
                    Action_Choose $1
    
            else
                     mysqldump -uroot -p$1 $DBNAME > /mnt/mysqldump/${DBNAME}.sql
                    echo "$DBNAME is backup in /mnt/mysqldump/${DBNAME}.sql"
            fi
    done

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70]

## 2.自动部署论坛 ##

#!/bin/bash
    echo "It's installing softwares ..."
    yum install php php-mysql mariadb-server httpd expect -y &> /dev/null
    echo "Installation is over "
    
    sed '/\[mysql\]/askip-networking=1' /etc/my.cnf -i /etc/my.cnf
    systemctl start mariadb httpd
    systemctl stop firewalld
    
    echo "configure services..."
    mysql_secure_installation  &> /dev/null <<EOF
    
    y
    westos
    westos
    y
    y
    y
    y
    EOF
    
    Download()
    {
    /usr/bin/expect <<-EOF
    spawn scp root@172.25.60.16:/home/kiosk/Downloads/Discuz_X3.2_SC_UTF8.zip .
    expect {
    "*password:" { send "westos\r"}
    }
    expect eof
    EOF
    }
    cd /var/www/html
    Download
    unzip Discuz_X3.2_SC_UTF8.zip &> /dev/null
    chmod 777 /var/www/html/upload -R
    firefox http://172.25.60.11/upload

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 1]

注意：selinux=premissive  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 3]![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 4]![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 5]![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 6]

## 3.自动登陆脚本 ##

#!/bin/bash
    Auto_Ssh()
    /usr/bin/expect <<EOF
    spawn ssh root@$1 hostname
    "yes/no" {  send "westos\r" }
    }
    expect eof
    EOF
    }
    for IP in {1..5}
    do
    	ping  -c1 -w1 172.25.254.$IP &> /dev/null
    	if [ "$?" -eq "0"]
    	then
    		echo "172.25.254.$IP `Auto_Ssh 172.25.254.$IP | tail -n 1 `"
    		fi
    done

## 4.排序问题 ##

方法1：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 7]  
方法2：  
![在这里插入图片描述][20190620192535641.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70]: /images/20220110/2b8e5bd41d8948b3a356b49de65cb005.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 1]: /images/20220110/11296c1eee274b06901f1d4e8e01e286.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 2]: /images/20220110/831e5b4774834ffbb2554d63f4e85883.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2019062011210245.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20190620112128387.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20190620112137311.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 6]: /images/20220110/ac677c4e34b74fdc880b2563eab0fadd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 7]: /images/20220110/88abf90380e14c2590af2ec9626b5693.png
[20190620192535641.png]: /images/20220110/acf0b42ce99c46bc8bf75c41ad848da4.png