Connect Oracle and Import to MySQL

#!/bin/bash

LogDirectory='/var/tmp/logs'
DataDirectory='/var/tmp/data'

DBUSER='adminadm'
DBUSERPASSWORD='aaaaaaaaaaaa'
DB='******************.com.vn'
NS='abcd'


end=`date +"%H:%M:%S" `
start=`echo $end | awk -F":" '{start=$1-1} END {print start":"$2":"$3}'`
echo $start $end

sqlplus64 -s <<EOF  > ${LogDirectory}/query.log
${DBUSER}/${DBUSERPASSWORD}@//${DB}:1521/${NS}
set linesize 32767
set feedback off
set heading off

spool /var/tmp/data/out.txt
select MS_TRANS, CREDITOR, SERVICECODE, AMOUNT, CREATED, MS_RESULT, PARTNER_RESULT,EXT_ACTION
from M_SERVICE_TRANS WHERE CREATED BETWEEN TO_DATE('2016-1-9 $start','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2016-1-9 $end','yyyy-mm-dd hh24:mi:ss')
;

spool off
EOF

sed -i -e 's/  */ /g' -e '/^$/d' -e 's/ $//g' /var/tmp/data/out.txt
#sed -i 's/  */|/g' /var/tmp/data/out.txt
#awk -F "|" '{print $4 "|" $5}' /var/tmp/data/out.txt | grep 2"|"0 | wc -l  #Check so luong thanh cong cua 1 TID

echo "show all tables"
mysql -h 127.0.0.1 --local-infile=1 -u root -pshiftenter <<EOFMYSQL

use test1
LOAD DATA LOCAL INFILE '/var/tmp/data/out.txt'
INTO TABLE trans COLUMNS TERMINATED BY ' '

;
EOFMYSQL
echo "OK!!!!!!!!!!!"