如果没有数据库软件的话,如何安装数据库
https://blog.csdn.net/qwefyjwww/article/details/84619183
以下为脚本
#!/bin/bash
MYUSER=root
MYPASS=westos
MYCMD="mysql -u$MYUSER -p$MYPASS"
MYDUMP="mysqldump -u$MYUSER -p$MYPASS"
DBPATH=/home/backup
for dbname in tom harry natasha
do
$MYCMD -e "create database $dbname"
done
[ ! -d "$DBPATH" ] && mkdir -p $DBPATH
for dbname in `mysql -uroot -pwestos -e "show databases;" | sed '1,2d' |egrep -v "mysql|schema"`
do
$MYDUMP $DBNAME | gzip > $DBPATH/${dbname}_$(date +%F).sql.gz
done
for dbname in tom harry natasha
do
echo ========${dbname}.test========
$MYCMD -e "use $dbname;select * from ${dbname}.test;"
done
2.添加一个判断,判断是否已经存在压缩包i
#!/bin/bash
mkdir -p /mnt/mysqldump
DATABASE=`mysql -uroot -pwestos -e "show databases;" | sed '1,2d' | egrep -v "mysql|schema"`
for MYSQL_NAME in $DATABASE
do
if [ -e /mnt/mysqldump/${MYSQL_NAME}.sql ];then
read -p "${MYSQL_NAME} has been dumped!
[S]kip [B]ackup [O]verwrite [E]xit
please input the action:" ACTION
case $ACTION in
s|S)
;;
b|B)
mysqldump -uroot -p$1 $MYSQL_NAME > /mnt/mysqldump/${MYSQL_NAME}_backup.sql
;;
o|O)
mysqldump -uroot -p$1 $MYSQL_NAME > /mnt/mysqldump/${MYSQL_NAME}.sql
;;
e|E)
echo -e "Bye"
exit 0
esac
else
mysqldump -uroot -p$1 $MYSQL_NAME > /mnt/mysqldump/${MYSQL_NAME}.sql
echo -e "$MYSQL_NAME is backuped!"
fi
done