shell导入mysql数据库

一定格式的文件可以直接自动通过shell导入数据库，例如文件格式用“，”分割字段，导入mysql数据库，如下操作：

 

建立shell文件，例如loadin.sh,内容如下：

 

#--------------------------------------------------------

#!/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
#-------------------------------------------------------

 

其中：用户名、密码、数据库、数据表、导入文件名 需要修改，也可根据需要记录这个shell执行日志,TODAY是可以做记录的时间。

 

csslog.txt文件内容如下：

 

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