mysql---备份数据

#!/bin/bash#owner:bi#cronTime: #inputData:WORDBANK #describe:export data from WORDBANK to host 240 #note:source /etc/profileik_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.txtecho ${ansj_dir}/stopword.txt finished!# export the name list to filemysql  -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`# loopfor 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 filemysql  -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}.txtcp ${stoppool}/${i}/${i}.txt ${ik_dir}/${i}.txt echo ${ik_dir}/${i}.txt ${stoppool}/${i}/${i}.txt finished!# end loopdonecp -r ${stoppool}/* ${ik_dir_opt}/