#!/bin/bash

HOST="ホスト名"
USER="ユーザ名"
PASSWORD="パスワード"
DATABASE="データベース名"
DDL_FILE="出力ファイルパス"

SQL_COMMAND="mysql --default-character-set=utf8 -h ${HOST} -u ${USER} -p${PASSWORD} -D ${DATABASE}"

rm -f ${DDL_FILE}
for t in `echo "SHOW TABLES" | ${SQL_COMMAND}`
do
    if [ ${t} = "Tables_in_hapitas" ]; then
        continue
    fi
    echo "SHOW CREATE TABLE $t\G" | ${SQL_COMMAND} >> ${DDL_FILE}
done