#!/bin/bash

if [ $(whoami) = "root" ]; then

   echo -n "### DBNAME : " ; read dbname

   for i in $(mysql -e "use $dbname; show table status;"|awk \
     '{print $6,$8}'|sed -ne '/[0-9]/p');do
   size=$(( $size + $i ))
   done

else

   echo -n "### DBNAME : " ; read dbname
   echo -n "### DBUSER ( default $dbname ) : " ; read dbuser
     [ ! $dbuser ] && dbuser=$dbname
   echo -n "### DBPASS : " ; read dbpass

   for i in $(mysql -u$dbuser -p$dbpass -e "use $dbname; show \
      table status;"|awk '{print $6,$8}'|sed -ne '/[0-9]/p');do
   size=$(( $size + $i ))
   done

fi

echo "디비 사이즈 : $size bytes"