1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
[root@localhost opt]
# cat color.sh
#!/bin/bash
#字颜色变量
BLACK=
"\033[30m"
#黑色
RED=
"\033[31m"
#红色
GREEN=
"\033[32m"
#绿色
YELLOW=
"\033[33m"
#黄色
BLUE=
"\033[34m"
#蓝色
PURPLE=
"\033[35m"
#紫色
SKY_GREEN=
"\033[36m "
#天绿色
WHITE=
"\033[37m"
#白色
#字背景颜色变量
BLACK_WHITE=
"\033[40;37m"
#黑底白字
RED_WHITE=
"\033[41;37m"
#红底白字
GREEN_WHITE=
"\033[42;37m"
#绿底白字
YELLOW_WHITE=
"\033[43;37m"
#黄底白字
BLUE_WHITE=
"\033[44;37m"
#蓝底白字
PURPLE_WHITE=
"\033[45;37m"
#紫底白字
WHITE_BLACK=
"\033[47;30m"
#白底黑字
SKY_BLUE_WHITE=
"\033[46;37m"
#天蓝底白字
#闪炼变量
FLICKER=
"\033[05m"
#头部
OUTPUT=
"echo -e"
#尾部
TAILS=
"\033[0m"
#使用方法
#$OUTPUT $RED "红色字" $TAILS
#$OUTPUT $WHITE_BLACK "白底黑字" $TAILS
#$OUTPUT $YELLOW$FLICKER "黄色闪炼字" $TAILS
|
把文件里的sql文件按从高到下的顺序导进数据库
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
#!/bin/bash
OUTPUT=
"echo -e"
TAILS=
"\033[0m"
GREEN=
"\033[32m"
RED=
"\033[31m"
FLICKER=
"\033[05m"
DATA=`
cat
$1 |
wc
-l`
for
((i=1;i<=$DATA;i++))
do
SQL=`
head
-$i $1 |
tail
-1`
mysql -u$2 -p$3 < $SQL
NU=$?
if
[ $NU -
eq
0 ];
then
$OUTPUT $GREEN
"$SQL exculde success"
$TAILS
echo
else
$OUTPUT $RED$FLICKER
"$SQL exculde eroor!"
$TAILS
echo
fi
done
|
MySQL主从同步监控
1
2
3
4
5
|
[root@localhost ~]
# (echo "quit") | telnet 127.0.0.1 22 #()放到子shell执行
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is
'^]'
.
Connection closed by foreign host.
|
1
2
3
4
5
6
7
8
|
[root@ryzc32 opt]
# cat telnet.sh
#!/bin/bash
JG=`
echo
-e
"\n"
| telnet 192.168.1.30 22 |
grep
Connected |
wc
-l`
if
[
"$JG"
== 1 ];
then
echo
"0"
#如果JG等于1,端口为通,输出0
else
echo
"1"
#如果JG等于0,端口不通,输出1
fi
|
1
2
3
4
5
6
7
8
|
[root@localhost opt]
# cat nmap.sh
#!/bin/bash
namp=`nmap 192.168.100.50 -p 22 |
grep
open
|
wc
-l`
if
[
"$namp"
== 1 ];
then
echo
0
else
echo
1
fi
|
1
2
3
|
[root@localhost opt]
# cat nc.sh
#!/bin/bash
nc -w 5 192.168.100.50 22 &&
echo
0 ||
echo
1
|
1
2
3
4
5
6
7
8
|
[root@mndg248 opt]
# cat url_mon.sh
#!/bin/bash
wget -T 10 -c -q --spider www.baidu.com && RETVAL=$?
if
[
"$RETVAL"
== 0 ];
then
echo
"0"
else
e cho
"1"
fi
|
一健安装Zabbix