在服務器上發現的定時的導入腳本，記錄下來。還是很有用的
30 06 * * * /data/dmsp/shell/crontab_search_stats_import.sh >> /data/dmsp/logs/crontab_search_stats_import.log
#!/bin/sh
y=$(date -d "-1 day" +%Y)
m=$(date -d "-1 day" +%m)
d=$(date -d "-1 day" +%d)
#/data/dmsp/ftp/dim_stats/2009/09/14
act=dim_stats
mypath=/data/dmsp/ftp/${act}/${y}/${m}/$wmqeeuq/
echo $mypath
statpath=${mypath}${act}${y}${m}$wmqeeuq.tar.bz2.state
for(( j=1; j<10000; j=j+1))
do
if [ -d "${statpath}" ] ; then
tar xjf ${mypath}${act}${y}${m}$wmqeeuq.tar.bz2 -C ${mypath}
mysql -h 127.0.0.1 -P3306 -u root -pmysql -e "LOAD DATA INFILE '${mypath}part-00000' INTO TABLE dmsp.dmsp_veidoo character set utf8 FIELDS TERMINATED BY '\t' lines terminated by '\n'";
break
else
echo "[${j}:1000] not ready. sleep 10 seconds then retry."
sleep 10
fi
don
整理 www.aygfsteel.com/Good-Game