mysql profile模板

.prod_profile
#!/bin/sh
echo "Now run on Server DB:"
echo "-----------------------------------------------------------------------------------------------------"
#netstat -an|grep mysql|grep LISTENING|awk -F / '{print $3}'| awk -F _ '{print $2$3}'|awk -F . '{printf"%s | ",$1}'
netstat -an|grep mysql|grep LISTENING|awk -F / '{print $3}'
echo " "
echo "-----------------------------------------------------------------------------------------------------"
echo "In info file DB: "
echo "-----------------------------------------------------------------------------------------------------"
awk -F: '{printf"%s | ",$1}' /etc/com/shell/db_my.txt
echo " "
echo "-----------------------------------------------------------------------------------------------------"
echo -n "Please Enter database sid:"
read SID;
if [ "$SID" = "" ]; then
echo "you havn't Enter your db name!";
# unset ORACLE_SID
else if awk -F: '{print $1}' /etc/com/shell/db_my.txt|grep -w $SID
then
export MYDATABASE=$SID;
export basedir=`awk -F: '{if ($1 == "'$MYDATABASE'") {print $2; exit}}' /etc/com/shell/db_my.txt`
export datadir=`awk -F: '{if ($1 == "'$MYDATABASE'") {print $3; exit}}' /etc/com/shell/db_my.txt`
export socket=`awk -F: '{if ($1 == "'$MYDATABASE'") {print $4; exit}}' /etc/com/shell/db_my.txt`
export ENCODING=`awk -F: '{if ($1 == "'$MYDATABASE'") {print $5; exit}}' /etc/com/shell/db_my.txt`
export PD=`awk -F: '{if ($1 == "'$MYDATABASE'") {print $6; exit}}' /etc/com/shell/db_my.txt`
else
echo "The database name not exist in /etc/com/shell/db_my.txt";
#unset MYDATABASE;
fi
fi

umask 022
export TERM=vt100
export EDITOR=vi
export PATH=$basedir/bin:/sbin:/usr/sbin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
export PS1="`hostname`:$MYDATABASE > "
#export ORACLE_DOC=$ORACLE_BASE/doc
export LD_LIBRARY_PATH=$basedir/lib:$LD_LIBRARY_PATH
alias mysql='$basedir/bin/mysql -uroot -S"$socket" -p"$PD"'
export TMP=/tmp
export PATH

cat /etc/com/shell/db_my.txt
inst_name:/dba/app/mysql/5.7.18:/mysql_data/inst_name/data/inst_name/data:/mysql_data/inst_name/data/mysql_inst_name.sock:utf8mb4:pwd