summaryrefslogtreecommitdiff
path: root/localserver/initdb.sh
diff options
context:
space:
mode:
authorAndrei Karas <akaras@inbox.ru>2014-12-01 00:38:00 +0300
committerAndrei Karas <akaras@inbox.ru>2014-12-01 00:38:00 +0300
commit8c023395258e35e78464155de47c03341630d288 (patch)
tree9ff93ed68a5afccaf002237450124eb4a6c6e1dc /localserver/initdb.sh
parentb5042022ac2b5f0183e2c53ad9bdebfa409eb212 (diff)
downloadtools-8c023395258e35e78464155de47c03341630d288.tar.gz
tools-8c023395258e35e78464155de47c03341630d288.tar.bz2
tools-8c023395258e35e78464155de47c03341630d288.tar.xz
tools-8c023395258e35e78464155de47c03341630d288.zip
add tools for managing local server.
Diffstat (limited to 'localserver/initdb.sh')
-rwxr-xr-xlocalserver/initdb.sh18
1 files changed, 18 insertions, 0 deletions
diff --git a/localserver/initdb.sh b/localserver/initdb.sh
new file mode 100755
index 0000000..82f9257
--- /dev/null
+++ b/localserver/initdb.sh
@@ -0,0 +1,18 @@
+#!/bin/bash
+
+cd ../../server-data/sql-files
+
+echo Creating db and user...
+echo Enter mysql root password:
+mysql --force -u root -p <./init.sql
+
+export CMD="mysql -u evol -pevol evol"
+
+echo Creating tables...
+$CMD <main.sql
+$CMD <mob_skill_db.sql
+$CMD <mob_skill_db2.sql
+$CMD <logs.sql
+$CMD <item_db_re.sql
+$CMD <mob_db_re.sql
+$CMD <mob_skill_db_re.sql