-
-
Notifications
You must be signed in to change notification settings - Fork 401
/
reset-database.sh
51 lines (40 loc) · 1.35 KB
/
reset-database.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
#!/usr/bin/env bash
set -e
while :; do
echo -n "Provide database name: "
read DATABASE_NAME
if mysql -Nse 'SHOW DATABASES;' | grep "${DATABASE_NAME}" -q; then
break
else
echo "Database ${DATABASE_NAME} does not exist. Try again"
fi
done
# User confirmation
echo "Database ${DATABASE_NAME} is going to be deleted and recreated"
echo "Are you sure you want proceed?"
read -p "y/N: " CONFIRMATION
if [[ ${CONFIRMATION} != "y" && ${CONFIRMATION} != "Y" ]]; then
exit
fi
# Dump
DUMP_FILE=./${DATABASE_NAME}_$(date +%Y%m%d_%H%M%S_%Z).mysqldump.sql
echo "Dumping ${DATABASE_NAME}"
mysqldump "${DATABASE_NAME}" >"${DUMP_FILE}"
echo "Dump saved at ${DUMP_FILE}"
# Recreate
SQL="DROP DATABASE ${DATABASE_NAME};"
SQL="${SQL} CREATE DATABASE ${DATABASE_NAME} DEFAULT CHARSET utf8;"
mysql -e "${SQL}"
echo "Database recreated"
# Grant privileges
echo "Do you want grant all privileges to app db user?"
read -p "y/N: " CONFIRMATION
if [[ ${CONFIRMATION} == "y" || ${CONFIRMATION} == "Y" ]]; then
read -p "User: " -ei "openboxes" USER
read -p "Host: " -ei "localhost" HOST
APP_DATABASE_USER=${USER}@${HOST}
mysql -e "GRANT ALL ON ${DATABASE_NAME}.* to ${APP_DATABASE_USER};"
echo "All privileges granted to ${APP_DATABASE_USER}"
fi
echo "Finished resetting. You can now restart openboxes."
echo "If you are using tomcat, run: sudo service tomcat restart"