[Mysql, ShellScript] Import Data sh 파일

# !/bin/bash

DIR='pwd'

HOST=localhost

USER=eunbi

PW=eunbi123!

DB=eunbi

echo  "[ LOADER ] Start : " $(date +%F) $(date +%T) >>  ./log/result_import.txt

TNAME=eunbi_data

FDIR=$DIR/data/

  TOTAL_START_TIME=$(date +%s)

  

  echo -e "DIR Name : $FDIR"

  for FNAME in $(ls $FDIR)

  do

    START_TIME=$(date +%s)

    echo $FNAME

    echo $(mysql --local-infile=1 -u$USER -p$PW $DB -e "LOAD DATA LOCAL INFILE '$FDIR/$FNAME' INTO TABLE $TNAME CHARACTER SET UTF8 FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ";)

    END_TIME=$(date +%s)

    echo "$FNAME ( $(expr $END_TIME - $START_TIME) )"

  done

  TOTAL_END_TIME=$(date +%s)

  echo -e "$(date +%F) $(date +%T) $line Insert Finished ( Runtime: $(expr $TOTAL_END_TIME - $TOTAL_START_TIME) )\n"