forked from ocproducts/composr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_init.sh
22 lines (17 loc) · 859 Bytes
/
db_init.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#!/bin/bash
# Create a MySQL database specified in _config.php
# Primarily designed for synching databases within the context of a revision control system
DB_HOST=$(cat _config.php|sed -n "s/\$SITE_INFO\['db_site_host'] = '\(.*\)';/\1/p")
DB_USER=$(cat _config.php|sed -n "s/\$SITE_INFO\['db_site_user'] = '\(.*\)';/\1/p")
DB_PASS=$(cat _config.php|sed -n "s/\$SITE_INFO\['db_site_password'] = '\(.*\)';/\1/p")
DB_NAME=$(cat _config.php|sed -n "s/\$SITE_INFO\['db_site'] = '\(.*\)';/\1/p")
if [ -z "${DB_NAME}" ];
then
echo "_config.php has not been configured. You must install Composr, or grab an install's _config.php and db.sql"
exit 0
fi
Q1="CREATE DATABASE IF NOT EXISTS ${DB_NAME};"
Q2="GRANT ALL ON *.* TO '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASS}';"
Q3="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}"
mysql -h${DB_HOST} -uroot -p -e "$SQL"