日志每天生成。。
我实验把此语句mysql -e"load data local infile '/usr/local/aa.net-access_log_20110210' into table YD20110209 fields terminated by ' ' enclosed by '"';" 保存到文件为test中
在linux命令中 mysql <test 能行!!能成功我想要的是load data local infile '/usr/local/aa-access_log_'date +%Y%m%d'' into table lt'date -d "1 days ago" +%Y%m%d' fields terminated by ' ' enclosed by '"'; 也能成功!!该怎么修改成功呢?
请各位指教
我实验把此语句mysql -e"load data local infile '/usr/local/aa.net-access_log_20110210' into table YD20110209 fields terminated by ' ' enclosed by '"';" 保存到文件为test中
在linux命令中 mysql <test 能行!!能成功我想要的是load data local infile '/usr/local/aa-access_log_'date +%Y%m%d'' into table lt'date -d "1 days ago" +%Y%m%d' fields terminated by ' ' enclosed by '"'; 也能成功!!该怎么修改成功呢?
请各位指教
#!/bin/bash
ip1=`date +%Y%m%d`
ip2=`date -d -1days +%Y%m%d`
ip3=`date -d -2days +%Y%m%d`sed -i "s/${ip3}/${ip2}/g" load依次运行
./set_load.shmysql < load.sh打完收工!!