summaryrefslogtreecommitdiff
path: root/localserver/initdb.sh
blob: 074f8c5c08bb63ee623cfcd8414501a1cbdae2f1 (plain) (blame)
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
#!/usr/bin/env bash

export DIR="$(pwd)"
export VER=$(cat versions/sqlver 2>/dev/null)

cd ../../server-data/sql-files

echo Creating db and user...
echo Enter mysql root password:
mysql --force -u root -p <./init.sql
result=$?
if [ "$result" != 0 ]; then
    echo Password failed. Trying with sudo...
    sudo mysql --force -u root <./init.sql
fi

export CMD="mysql -u evol -pevol evol"

echo Creating tables...
$CMD <main.sql
$CMD <logs.sql

if [[ -z "${VER}" ]]; then
    mkdir ${DIR}/versions
    echo "20" >${DIR}/versions/sqlver
fi