i=0 j=0 STOP=/tmp/stop.ini rm -f $STOP #mysql -u root --socket=/tmp/mysql.sock -e "source ./table.dat" while [ $i -le 1 ] do mysql -u root --socket=/tmp/mysql.sock -e "source ./table1.dat" echo looped if [ -f $STOP ] then echo "STOP file exists: $STOP" i=`expr $i + 2` fi j=`expr $j + 2` if [ $j -ge 300 ] then echo truncated mysql -u root --socket=/tmp/mysql.sock -e "truncate matable" fi done rm -f $STOP