#!/bin/sh

read -p "Enter username: " dbuser
read -p "Enter password: " -s dbpass
echo ""

callAction()
{
  echo "Optimizing all tables in $db"

  tables=$( mysql -D $db -e "SHOW TABLES\G;"|grep 'Tables_in_'|sed -n 's/.*Tables_in_.*: \([_0-9A-Za-z]*\).*/\1/p' )

  for table in $tables; do
    mysql -u$dbuser -p$dbpass -D $db -e "OPTIMIZE TABLE $table;"
  done
}

for db in $(echo "show databases" | mysql -u$dbuser -p$dbpass | grep -v Database); do
  if [[ $db != information_schema ]] && [[ $db != adminv2 ]] && [[ $db != proftpd ]] && [[ $db != mysql ]] && [[ $db != nowcom_nl ]] && [[ $db != nucommunity_nu ]] && [[ $db != clubworkx ]] ; then
    callAction
  fi
done