数据库相关

一.清理数据库

#!/bin/bash
if [ $# -ne 1 ]; then
    echo "请输入数据库名称"
    exit -1
else
    echo "开始清理数据库$*"
fi

USERNAME=${whoami}
SQLDIR="/home/${USERNAME}/sql"

mysql -h 192.168.165.122 -utest -ptest -e "drop database $1"

if [ $? -ne 0] 
then
    echo "数据库${1}不存在"
    exit 1
fi

mysql -h 192.168.165.122 -utest -ptest << EOF
    use $1;
    source ${SQLDIR}/test.sql
EOF

echo "清理数据库${1}完成"

 

二.导出数据库

#!/bin/bash

if [ $# -ne 2 ]; then
    echo "参数错误,需要2个参数"
    exit -1
fi

mysqldump -utest -ptest -h 192.168.165.122 --default-character-set=latin1 --skip-opt --single-transaction 
-q --no-autocommit -R --triggers -c -t $1 SQLBASE --where="charid=$2" > ~/$2.sql

echo "导出成功,文件为:~/$2.sql"

 

三.导入数据库
#!/bin/bash

if [ $# -ne 4];then
    echo "参数错误,需要4个参数"
    exit -1
else
    echo "参数正确，导入数据库 参数:$*"
    #printf "参数:%s\n" $@
fi
    
sqlcharid=$(cat $2 | grep WHERE | awk -F"=" '{print $2}')

mysql -h 192.168.165.122 -utest -ptest << EOF
    use $1;
    delete from SQLBASE where charid=${sqlcharid};
    delete from SQLBASE where name="${4}";
    source $2;
EOF

mysql -h 192.168.165.122 -utest -ptest $1 -e "update SQLBASE set uuid='$3', name='$4', passwd='1' where charid=$sqlcharid;"

echo "导入完成,账号:$3,密码:1"