|
一定格式的文件可以直接自動通過shell導(dǎo)入數(shù)據(jù)庫,例如文件格式用“,”分割字段,導(dǎo)入mysql數(shù)據(jù)庫,如下操作:
建立shell文件,例如loadin.sh,內(nèi)容如下:
#--------------------------------------------------------
#!/bin/bash
TODAY=`date +%Y%m%d` TODAY1=`date +%Y/%m/%d` echo "TODAY1=$TODAY1 == TODAY=$TODAY " TMPFILE="`basename $0`.$$"
echo "TMPFILE=$TMPFILE" MYSQL=/usr/bin/mysql
USERNAME=HP_USER PASSWD=userHP DATABASE=test echo "load data infile ‘/usr/local/mysql/csslog.txt‘ into table csslog fields terminated by ‘,‘ ;" > $TMPFILE
$MYSQL -u $USERNAME --password=$PASSWD -D $DATABASE < $TMPFILE rm $TMPFILE
#------------------------------------------------------- 其中:用戶名、密碼、數(shù)據(jù)庫、數(shù)據(jù)表、導(dǎo)入文件名 需要修改,也可根據(jù)需要記錄這個shell執(zhí)行日志,TODAY是可以做記錄的時間。
csslog.txt文件內(nèi)容如下:
172.16.28.112,[18/Jun/2007:14:01:22,/css/common.css
172.16.28.112,[18/Jun/2007:14:01:23,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:23,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:28,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:31,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:32,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:33,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:34,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:35,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:36,/css/common.css 172.16.28.112,[18/Jun/2007:14:01:40,/css/common.css 172.16.28.114,[18/Jun/2007:14:32:19,/scr_pianhua.css 172.16.28.114,[18/Jun/2007:14:32:19,/page_play.css 172.16.28.113,[18/Jun/2007:14:36:03,/index/css/page_qr.css 172.16.28.113,[18/Jun/2007:14:36:03,/index/css/scr_maipiao.css 172.16.28.114,[18/Jun/2007:14:36:45,/scr_pianhua.css 172.16.28.114,[18/Jun/2007:14:36:45,/page_play.css 172.16.28.114,[18/Jun/2007:14:37:52,/scr_pianhua.css 172.16.28.114,[18/Jun/2007:14:37:52,/page_play.css 172.16.28.113,[18/Jun/2007:14:43:58,/css/common.css 172.16.28.113,[18/Jun/2007:14:43:58,/css/common.css 172.16.28.113,[18/Jun/2007:14:43:59,/css/common.css 172.16.28.113,[18/Jun/2007:14:43:59,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:01,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:02,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:03,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:04,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:10,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:12,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:12,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:18,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:19,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:20,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:21,/css/common.css 172.16.28.113,[18/Jun/2007:14:44:23,/css/common.css 172.16.28.110,[18/Jun/2007:14:49:09,/css/common.css 172.16.28.114,[18/Jun/2007:14:52:51,/scr_pianhua.css 172.16.28.114,[18/Jun/2007:14:52:51,/page_play.css |
|
|