#!/bin/bash
DB_NAME={dbname}
DB_HOST={dbhost}
DB_USER={user}
DB_PASS={password}
DUMP_FILE="./db_instance.sql"

mysqldump -h $DB_HOST -u $DB_USER -p$DB_PASS --add-drop-table --no-data $DB_NAME | grep ^DROP | mysql -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME
mysql -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME < $DUMP_FILE