gistfile1.sh

#!/usr/bin/env bash

if [ $# -eq 2 ]; then
  user=$1
  dbname=$2
  basecmd="mysql -u ${user} -D ${dbname}"
elif [ $# -eq 3 ]; then
  user=$1
  PASS=$2
  dbname=$3
  basecmd="mysql -u ${user} -p$PASS -D ${dbname}"
else
  echo "usage: mysqltrunc user [pass] database" >&2
  exit 1
fi

tables=$(${basecmd} -e "SHOW TABLES;" | grep -v "+--" | grep -v "Tables_in_${dbname}")
if [ $? -ne 0 ]; then
  echo "Unable to retrieve the table names." >&2
  exit 1
fi

cmd=""

for table in ${tables}; do
  cmd="${cmd} TRUNCATE ${table};"
done

$(${basecmd} -e "${cmd}")