shell脚本连接mysql,执行sql导出文件
#!/bin/bash
source /etc/profile
source ~/.bash_profile
set -o nounset
set -o errexit
#Author: gupx
#Time: 2021-07-02 13:00:00
#Name: test.sh
#Description: shell脚本连接mysql
useage(){
echo “useage: ./test.sh M/D”
echo “example: ./test M/D”
}
log(){
now_time=\'[\’$(date +”%Y-%m-%d %H:%M:%S”)\’]\’
echo ${now_time} $1 | tee -a ${log_file}
}
#导出文本路径
file_path_table=”/usr/tmp/test/”
#mysql相关变量
STNAME=”xx.xx.xx.xxx”
PORT=”xxxx”
USERNAME=”test”
PASSWORD=”123456″
DBNAME=”TEST_DB”
use_db_sql=”use ${DBNAME}”
test_table_sql=”select * from test_table;”
test_table1_sql=”select * from test_table1;”
#连接mysql
exec_files(){
exec_sql=$1;
file_name=`echo $exec_sql | grep -Po \'(?<=from ).*(?=;)\’`
exec_result=`mysql -h${STNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e “${exec_sql}”`
echo “${exec_result}” | sed \’s/\t/|/g\’ > ${file_path_table}${file_name}_${day_date}.txt
}
main(){
exec_files “$test_table_sql”;
}
main;