dbreset.sh

#!/bin/bash
# Drop and recreate the configured database, then load a dump into it.
# Uses the dump given as the first argument, or $DBDUMP otherwise.
#   ./dbreset.sh                # -> reload from $DBDUMP
#   ./dbreset.sh snapshot.sql   # -> reload from snapshot.sql
set -euo pipefail

DIR="$( cd -P "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
. "$DIR/_init.sh"

dump="${1:-$DBDUMP}"
if [ ! -f "$dump" ]; then
    echo "$dump doesn't exist, falling back to ${DBDUMP}" >&2
    dump="$DBDUMP"
fi
[ -f "$dump" ] || { echo "${dump} doesn't exist, exiting" >&2; exit 2; }

echo "Dropping database ${DBNAME} ..."
printf 'DROP DATABASE IF EXISTS `%s`;\n' "$DBNAME" | db_exec notty "$MYSQL_CMD"

echo "Creating database ${DBNAME} ..."
printf 'CREATE DATABASE IF NOT EXISTS `%s` CHARACTER SET utf8mb4;\n' "$DBNAME" \
    | db_exec notty "$MYSQL_CMD"

"$DIR/dbpatch.sh" "$dump"