os-源
-----------------------------------------------------------------------
#!/bin/bash
# User specific environment and startup programs
source /home/oracle/.bash_profile
# default retetion
if [ $# == 1 ];then
DATE=${1}
else
DATE=`date -d yesterday +%Y%m%d`
fi
cd /data/script/mysql/mysql_report/
rm -rf we.csv
mysql -uroot -ppass < /data/script/mysql/mysql_report/report.sql

#-------------ftp file from master
FTP_IP=10.25.x.x
FTP_PORT=21
FTP_USER="user"
FTP_PWD="pass"
# ftp upload function
function FTP_PRO ()
{
/usr/bin/ftp -i -n < open ${FTP_IP} ${FTP_PORT}
user ${FTP_USER} ${FTP_PWD}
binary
put wepayreport.csv
bye
EOF
}
FTP_PRO

mysql
----------------------------------------------------------------------
select * INTO OUTFILE '/data/script/mysql/mysql_report/wepayreport.csv' FIELDS TERMINATED BY ',' FROM table;

os-目标
----------------------------------------------------------------------
#!/bin/bash
# User specific environment and startup programs
source /home/oracle/.bash_profile
# default retetion
if [ $# == 1 ];then
DATE=${1}
else
DATE=`date -d yesterday +%Y%m%d`
fi
cd /data/oracle/u02/wepay_email
rm -rf *.csv
#-------------ftp file from master
FTP_IP=10.25.x.x
FTP_PORT=21
FTP_USER="user"
FTP_PWD="pass"
# ftp upload function
function FTP_PRO ()
{
/usr/bin/ftp -i -n < open ${FTP_IP} ${FTP_PORT}
user ${FTP_USER} ${FTP_PWD}
binary
mget report.csv
bye
EOF
}
FTP_PRO

#--sqlloader
/data/oracle/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlldr report/pass control=report.ctl;

sqlloder
-----------------------------------------------------------------------------------
LOAD DATA
INFILE report.csv
truncate into table table_name
FIELDS TERMINATED BY "," TRAILING NULLCOLS
(
id,
create_time DATE 'YYYY-MM-DD HH24:MI:SS'
)

ITPub博客

sqlloder脚本

最新文章