[behoben, aber nicht verstanden][epgd] keinerlei EPG-Infos mehr via WebIF oder VDR, aber in der DB

#!/bin/bash

fUsage() {
  action="$1"
  case "$action" in
  5) $ECHO "$VERSION"
     exit 0
     ;;
  esac
  $ECHO
  case "$action" in
  4) $ECHO "wrong parameter!";;
  3) $ECHO "mutual exclusive parameters!";;
  2) $ECHO "missing parameter!";;
  1) $ECHO "unknown parameter!";;
  esac
  $ECHO "\tusage:\t$my_name [-a <action>][-h][-V]"
  $ECHO
  $ECHO "\t\t-a <action> \"backup\", \"recovery\" or \"reset\""
  $ECHO "\t\t-h          display this help"
  $ECHO "\t\t-V          displays version number and date"
  $ECHO
  exit $action

}

VERSION="version 0.01 / 23.09.2018"
ECHO="/bin/echo -e"
ECHON="/bin/echo -e -n"

while getopts a:hV OPTION
do
  case "$OPTION" in
  a) action="$OPTARG";;
  h) fUsage 0;;
  V) fUsage 5;;
  *) fUsage 4;;
  esac
done
shift `expr "$OPTIND" - 1`

[ -z "$action" ] && fUsage 2
case "$action" in
backup|recovery|reset)
  ;;
*)
  fUsage 4
  ;;
esac

# set -x
HOST="vdr"
USER="epg2vdr"
DATABASE="epg2vdr"
OUTDIR="/var/backup.epgd/"

declare -a MYTABLES
MYTABLES=(
  "channelmap"
  "parameters"
  "searchtimers"
  "users"
  "vdrs"
)
[ -r ~/.ssh/epgdpass ] && . ~/.ssh/epgdpass
if [ -n "$PASSWORD" ]
then
  case "$action" in
  backup)
    for _mytable in "${MYTABLES[@]}"
    do
      OUTFILE="${OUTDIR}${_mytable}.csv"
      [ -e "$OUTFILE" ] && rm -f "$OUTFILE"
      $ECHON "backing up \"${_mytable}\" to \"${OUTFILE}\" ... "
      mysql --host="$HOST" --database="$DATABASE" \
            --user="$USER" --password="$PASSWORD" \
            --execute="SELECT * FROM ${_mytable} INTO OUTFILE '${OUTFILE}' FIELDS TERMINATED BY ',' ENCLOSED BY '''' LINES TERMINATED BY '\\n';"
      case "$?" in
      0) $ECHO "OK." ;;
      *) $ECHO "Error!" ;;
      esac
      OUTFILE="${OUTDIR}${_mytable}.sql"
      [ -e "$OUTFILE" ] && rm -f "$OUTFILE"
      $ECHON "backing up \"${_mytable}\" to \"${OUTFILE}\" ... "
      mysqldump --host="$HOST" --user="$USER" --password="$PASSWORD" \
                "$DATABASE" "$_mytable" >"$OUTFILE"
      case "$?" in
      0) $ECHO "OK." ;;
      *) $ECHO "Error!" ;;
      esac
    done
    ;;
  recovery)
    $ECHON "Really? You will overwrite several tables [y|n] "
    read var
    case "$var" in
    y|Y)
      for _mytable in "${MYTABLES[@]}"
      do
        INFILE="${OUTDIR}${_mytable}.sql"
        $ECHON "recovering \"${_mytable}\" from \"${OUTFILE}\" ... "
        mysql --host="$HOST" --database="$DATABASE"\
              --user="$USER" --password="$PASSWORD" \
              <"$INFILE"
        case "$?" in
        0) $ECHO "OK." ;;
        *) $ECHO "Error!" ;;
        esac
      done
      ;;
    *)
      $ECHO "Aborted!"
      ;;
    esac
    ;;
  reset)
    $ECHON "Really? This function isn't tested yet [y|n] "
    read var
    case "$var" in
    y|Y)
      VIEWS=$( mysql --host="$HOST" \
                 --user="$USER" --password="$PASSWORD" \
                 --database="$DATABASE" \
                 --raw --batch \
                 --execute="SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_TYPE='view';" \
              | grep -vi "table_name"
             )
      for _view in $VIEWS
      do
        for _mytable in "${MYTABLES[@]}"
        do
          [ "$_view" = "$_mytable" ] && continue 2
        done
        $ECHON "dropping view \"${_view}\" ... "
        mysql --host="$HOST" --database="$DATABASE" \
              --user="$USER" --password="$PASSWORD" \
              --execute="DROP VIEW ${_view};"
        case "$?" in
        0) $ECHO "OK." ;;
        *) $ECHO "Error!" ;;
        esac
      done
      TABLES=$( mysql --host="$HOST" \
                  --user="$USER" --password="$PASSWORD" \
                  --database="$DATABASE" \
                  --raw --batch \
                  --execute="SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_TYPE='base table';" \
              | grep -vi "table_name"
             )
      for _table in $TABLES
      do
      for _mytable in "${MYTABLES[@]}"
        do
          [ "$_table" = "$_mytable" ] && continue 2
        done
        $ECHON "dropping table \"${_table}\" ... "
        mysql --host="$HOST" --database="$DATABASE" \
              --user="$USER" --password="$PASSWORD" \
              --execute="DROP TABLE ${_table};"
        case "$?" in
        0) $ECHO "OK." ;;
        *) $ECHO "Error!" ;;
        esac
      done
      ;;
    *)
      $ECHO "Aborted!"
      ;;
    esac
    ;;
  esac
else
  $ECHO "No password found to connect to database - abortig!"
fi