#!/bin/bash

#Script. Name:test_seal_activity.sh

#Descript. export data from seal_activity between now()-1 10:00:00 and now() 10:00:00

#define export DataBAse

DbName=testDB

#define userName and Passwd

#Dbusr=us_test

#Dbpasswd=us_test

#Dbport=port

#Dbhost=xx.xx.xx.xx

#define time export data

expdate=`date +%y%m%d`

echo ${expdate}

#define export table format

exptab=table_Name.OpenId_${expdate}.txt

echo ${exptab}

#导出数据非Linux本地

mysql -h ${Dbhost} -P ${Dbport} -u ${Dbusr} -p${Dbpasswd} -e "SELECT OpenId FROM ${DbName}.table_Name WHERE Seal_Count > 0 AND Create_Time BETWEEN CONCAT(DATE_ADD(CURDATE(),INTERVAL -1 DAY),' 10:00:00') AND CONCAT(CURDATE(),' 10:00:00')" > /data/ExpActivity/${exptab};

#导出数据在Linux Server

mysql -h ${Dbhost} -P ${Dbport} -u ${Dbusr} -p${Dbpasswd} -e "SELECT OpenId into outfile '/data/ExpActivity/${exptab}' FROM ${DbName}.table_Name WHERE Seal_Count > 0 AND Create_Time BETWEEN CONCAT(DATE_ADD(CURDATE(),INTERVAL -1 DAY),' 10:00:00') AND CONCAT(CURDATE(),' 10:00:00');"

sleep 1

cd /data/ExpActivity

zip -r Open_Id_${expdate}.zip ${exptab}

sleep 1

rm /data/ExpActivity/${exptab}

ITPub博客

select xxx into outfile from shell

最新文章