install/install.sh

   1 #!/bin/sh
   2 # my.gpodder.org initial database setup
   3 # Thomas Perl; 2010-03-31
   4
   5 USER=mygpo
   6 DB=mygpo
   7
   8 LOGFILE=install.log
   9 SQL_SCRIPTS="create-db.sql update-*.sql sanitizing-rules.sql"
  10
  11 MYSQL="mysql -u $USER $DB -vv"
  12
  13 cat <<EOF
  14
  15    ===================================
  16    my.gpodder.org Initial Installation
  17    ===================================
  18
  19   THIS SCRIPT IS INTENDED FOR INITIAL INSTALLATION ONLY.
  20   DO NOT USE THIS SCRIPT IF YOU ARE UPGRADING YOUR DB!!!
  21
  22 Press ENTER to continue or Ctrl+C to abort...
  23 EOF
  24
  25 read ME
  26
  27 (for file in $SQL_SCRIPTS; do
  28     $MYSQL < $file || exit 1
  29 done) 2>&1 | tee $LOGFILE
  30
  31 cat <<EOF
  32
  33   If you can read this, there is a high probability that
  34   everything went okay. Please check the screen output
  35   for details. In case of problems, the output has been
  36   written to a file that you can use for bug reporting:
  37
  38         $LOGFILE
  39
  40 EOF
  41