#!/bin/bash -e
USER='USER'
PASS='PASS'
DB='DB_NAME'
LOG_FILE="./mysql_table_count.log"


for TABLE in `mysql -u${USER} -p{PASS} -e "USE ${DB}; SHOW TABLES\G" | gawk '{ if (NR % 2 == 0) printf $2"\n"}'`
do
  echo "-----------   Getting ${TABLE} Information   -----------------------------" | tee -a "${LOG_FILE}"
  mysql -u${USER} -p${PASS} -e "SELECT count(*) FROM ${DB}.${TABLE};"  | tee -a "${LOG_FILE}"

  ELEVEL=$?
  if [ ${ELEVEL} -ne 0 ]; then
    echo "Failed: could not get information for ${TABLE}"  | tee -a "${LOG_FILE}"
  else
    echo "Success: ${TABLE}" | tee -a "${LOG_FILE}"
  fi
  echo '----------------------------------------' | tee -a "${LOG_FILE}"
done

exit 0