t3kit_db/restoredb.sh at master · t3kit/t3kit_db · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#!/bin/bash

DBHOST="localhost"

# SHOW DATABASES
mysql -uroot -p$DB_ROOT_PASSWORD -h$DB_CONTAINER_NAME -e "SHOW DATABASES;"

if [ "`mysql -uroot -p$DB_ROOT_PASSWORD -h$DB_CONTAINER_NAME -e 'show databases;' | grep ${DB_NAME}`" == "${DB_NAME}" ]; then

    # Drop database
    echo "Dropping DB $DB_NAME ..."
    mysql -uroot -p$DB_ROOT_PASSWORD -h$DB_CONTAINER_NAME -e "DROP DATABASE $DB_NAME;"

    # Create new database
    echo "Creating DB $DB_NAME ..."
    mysql -uroot -p$DB_ROOT_PASSWORD -h$DB_CONTAINER_NAME -e "CREATE DATABASE IF NOT EXISTS $DB_NAME CHARACTER SET utf8 COLLATE utf8_general_ci;"
    mysql -uroot -p$DB_ROOT_PASSWORD -h$DB_CONTAINER_NAME -e "GRANT ALL PRIVILEGES ON $DB_NAME.* TO '$DB_USER'@'$DBHOST' IDENTIFIED BY '$DB_PASSWORD';"
    mysql -uroot -p$DB_ROOT_PASSWORD -h$DB_CONTAINER_NAME $DB_NAME < /var/www/html/vendor/t3kit/db/t3kit8.sql
fi
echo "Done"