Import dump generated by mysqlpump

import.sh

#!/usr/bin/env sh

# Sample of use:
#
# ```sh
# sh import.sh backuped_database.sql
# ```
#
# @see https://hub.docker.com/r/mysql/mysql-server/
# @see https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html

set -eu

test -f "$1" || exit 2 # ENOENT

tmpfile=$(mktemp /tmp/mysql-import.XXXXXX)
cat "$1" | \
    perl -pe 's#`saved_database`.##g' | \
    perl -pe "s#^USE\s+.*##" | \
    perl -pe 's#ALGORITHM=(.*) DEFINER=`(.*)`@`(.*)` SQL SECURITY DEFINER##' \
        > "$tmpfile"

cat "$tmpfile" | \
    mysql -hlocalhost -uroot -p"${MYSQL_ROOT_PASSWORD}" "${MYSQL_DATABASE}"