blob: a2e566a28dd09f11febabd460a8105efbdca5f59 (
plain)
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
|
#!/bin/bash
set -e
mysql_client_ssl_flag='--skip-ssl'
importSQLFile() {
mysql --default-character-set=utf8mb4\
--init-command="SET NAMES UTF8;"\
$mysql_client_ssl_flag\
-u "$MYSQL_USER"\
-h "$MYSQL_HOST"\
-p"$MYSQL_PASSWORD"\
"$MYSQL_DATABASE"\
< "$1"
}
if [ "$(mysql $mysql_client_ssl_flag -u "$MYSQL_USER" -h "$MYSQL_HOST" -p"$MYSQL_PASSWORD" "$MYSQL_DATABASE" -e "show tables;" --batch | wc -l)" -eq 0 ]; then
# Check if demodata is required
if [ ! -z $DEMO_DATA ]; then
echo "INSTALL DEMODATA"
importSQLFile ./db/studip-demo-installation.sql
else
echo "INSTALL DB"
importSQLFile ./db/studip-basic-installation.sql
echo "INSTALL ROOTUSER"
importSQLFile ./db/studip-root-user.sql
fi
echo "INSTALLATION FINISHED"
else
echo "Found some SQL table. Skipping installation"
fi
|