mysql---备份数据

xiaoxiao2021-02-28  64

#!/bin/bash #owner:bi #cronTime: #inputData:WORDBANK #describe:export data from WORDBANK to host 240 #note: source /etc/profile ik_dir='/opt/cms_syc_seg/useDic/ik/stopword' stoppool='/auto_cron/cron-running/dam/cy_ad_dat/stoppool' ansj_dir='/opt/cms_syc_seg/useDic/ansj' ik_dir_opt='/opt/bin/UDF/useDic/ik/stopword' # export data in one file mysql -h"10.***.3.***" -u"bi" -p'****' -Ne "set names utf8; SELECT wordname FROM WORDBANK.stop_relation_bank WHERE flag=2" > ${ansj_dir}/stopword.txt echo ${ansj_dir}/stopword.txt finished! # export the name list to file mysql -h"10..3.2" -u"w" -p'****' -Ne "set names utf8; select distinct bankname from WORDBANK.wordbank where flag=0;" > ${ik_dir}/'bankname.txt' list=`cat ${ik_dir}/bankname.txt` # loop for i in $list;do # create dir if [ ! -d ${ik_dir}/$i ];then mkdir ${ik_dir}/${i} fi if [ ! -d ${stoppool}/$i ];then mkdir ${stoppool}/${i} fi # export data in each file mysql -h"10..3.218" -u"w" -p'34' -Ne "set names utf8; select wordname from WORDBANK.stop_relation_bank where bankname='${i}' " > ${stoppool}/${i}/${i}.txt cp ${stoppool}/${i}/${i}.txt ${ik_dir}/${i}.txt echo ${ik_dir}/${i}.txt ${stoppool}/${i}/${i}.txt finished! # end loop done cp -r ${stoppool}/* ${ik_dir_opt}/

转载请注明原文地址: https://www.6miu.com/read-64126.html

最新回复(0)