テンプレ

gistfile1.sh

#!/bin/bash
 
_DRYRUN=""
OPTIND_OLD=$OPTIND
OPTIND=1
while getopts "n" opts
do
  case $opts in
    n) _DRYRUN="TRUE" ;;
  esac
done
 
_SCRIPT_PATH=`echo $(cd $(dirname $0); pwd)`
_SQL_FILES=(`ls -dF ${_SCRIPT_PATH}/sql/*`)
 
if [ "$_DRYRUN" = "TRUE" ]; then
  for (( i = 0; i < ${#_SQL_FILES[@]}; i++ ))
  do
    echo "mysql -u user -p[password] < ${_SQL_FILES[$i]}"
  done
else
  for (( i = 0; i < ${#_SQL_FILES[@]}; i++ ))
  do
    mysql -u user -ppassword < ${_SQL_FILES[$i]}
  done
fi
 
exit 0