##########用户创建的脚本##########
#!/bin/bash
if
[ -z "$*" ]
then
echo "ERROR,Please give userfile and passwdfile"
exit 1
fi
if
[ ! -f /mnt/userfile ] || [ ! -f /mnt/passwdfile ]
then
echo "ERROR,Please check your userfile and passwdfile"
exit 1
fi
MAXLINE1=`wc -l /mnt/userfile | cut -d " " -f 1`
MAXLINE2=`wc -l /mnt/passwdfile | cut -d " " -f 1`
if
[ ! "$MAXLINE1" -eq "$MAXLINE2" ]
then
echo "the two files are not match"
exit 1
fi
for NUM in $( seq 1 $MAXLINE1 )
do
USERNAME=`sed -n ${NUM}p /mnt/userfile`
PASSWORD=`sed -n ${NUM}p /mnt/passwdfile`
useradd $USERNAME &>/dev/null
echo $PASSWORD | passwd --stdin $USERNAME
done
###########ssh脚本####################
#!/usr/bin/expect
set NAME [ lindex $argv 0 ]
set PASSWD [ lindex $argv 2 ]
set IPADDR [ lindex $argv 1 ]
spawn ssh $NAME@$IPADDR
expect {
"yes/no" { send "yes\r"; exp_continue }
"password" { send "$PASSWD\r"; exp_continue }
interact
}
#########数据备份############
#!/bin/bash
##database copy
##2017-3-10
read -p "need to back all data: " yn
read -p "please input your database passwd : " password
if
[ "$yn" = "y" -o "$yn" = "Y" ]
then
mysqldump -uroot -p$password --all-databases > backup.dump
else
read -p "Please input need backup database name: " NAME
mysqldump -uroot -p$password $NAME >$NAME.dump
fi
#########数据恢复############
#!/bin/bash
#recover database
#2017-3-10
read -p "Please input database password : " passwd
read -p "Please input recovered database name: " NAME
mysqladmin -uroot -p$passwd create $NAME
read -p "please input your bakcup name : " NAME1
mysql -uroot -p$passwd $NAME < $NAME1.dump