Import log files to MySQL database table

#!/bin/bash
#****************************************************************************
#*** The daily log in the/usr/local/data/directory, import the database
#*** Import data for one day:./load2mysql.sh 20140101
#*** importing a certain period of time data:./load2mysql.sh 20140101 20140110
#*** parameter imports yesterday's data by default:./load2mysql.sh
#****************************************************************************
#export path= $path:/d/mysql5.5/bin
#log_path =load2mysql.log
#echo ' date + '%y-%m-%d%T "' >>${log_path}
#echo "... Start Execution ">>${log_path}
Mysql_bin=/d/mysql5.5/bin

#args_num =$#
#if [$args _num-eq 0];then
# date1= ' date-d "-1 day" + "%y%m%d" '
# date2= ' date-d "-1 day" + "%y%m%d" '
#elif [$args _num-eq 1];then
3 date1=$1
# date2=$1
#elif [$args _num-eq 2];then
# date1=$1
# date2=$2
#else
# echo "... Parameter error, exit ">>${log_path}
# exit
#fi

#echo "... Parameter: [${date1}][${date2}] ">>${log_path}

#beg_s = ' date-d ' $date 1 "+%s"
#end_s = ' date-d ' $date 2 "+%s"
Pth= ' pwd '
#while ["$beg _s"-le "$end _s"];d o
#datestr = ' date-d @ $beg _s + "%y%m%d";
For dir in $ (ls.)
Do
#[-D $dir] && echo $dir

For f in $ (LS $dir)
Do
pth2= $pth/$dir/$f
For logfile in ' ls ${pth2} '
Do
Lgfile=${pth2}/${logfile}
#load_sql = "Load Data infile ${lgfile} into table ${dir} fields terminated by ' #@@# '"
#{mysql_bin}/mysql-u root-p ' 123456 ' sanguo_log-e "${load_sql}"
Dest_logfile=${pth}/${dir}/${f}/${dir}.txt
Echo ${dest_logfile}
MV ${lgfile} ${dest_logfile}
${mysql_bin}/mysqlimport-uroot-p ' 123456 '--fields-terminated-by= ' #@@# '--lines-terminated-by= ' \ r \ n ' sanguo_log ${ Dest_logfile}
RM ${dest_logfile}
Done
Done
Done

#mysqldump-u root-p ' ********** ' my_db tbl_logs >tbl_logs.sql

Import log files to MySQL database table