统计文件并且写入mysql中

#!/bin/bash  

dir='/usr'
now_date=$(date +"%Y-%m-%d")

d_h="xxx"
d_u="xxx"
d_p="xxx"
d_b='xxx'

for i in $(ls $dir)
do
    pdir=$dir/$i
    if [ ! -d "$pdir" ]; then
        echo "Skipping $pdir: Not a directory"  
        continue
    fi
    dirsize=$(du -sm "$pdir" | awk '{print $1}')
    sql_data="('$i', '$pdir', $dirsize, '$now_date')"
    query="INSERT INTO xxx(xxx, xxx, xxx, xxx) VALUES $sql_data"
 #   echo $query
    mysql -h$d_h -u$d_u -p$d_p $d_b -e "$query" 2>/dev/null
 #   mysql -h$d_h -u$d_u -p$d_p $d_b -e "$query" 2>/dev/dull
done