From f84c8dcc22f1499128893e62b0e15b4b592c47ba Mon Sep 17 00:00:00 2001
From: MatthewLi <matthew.lijun@huawei.com>
Date: Fri, 25 Mar 2016 03:55:53 -0400
Subject: adjust project directories

JIRA: BOTTLENECK-56

Change-Id: Ic9acad5eaa4917093bdb85a80960f796f5b4ba7f
Signed-off-by: MatthewLi <matthew.lijun@huawei.com>
---
 .../rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh   | 49 ++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100755 testsuites/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh

(limited to 'testsuites/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh')

diff --git a/testsuites/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh b/testsuites/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh
new file mode 100755
index 00000000..da07ab36
--- /dev/null
+++ b/testsuites/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh
@@ -0,0 +1,49 @@
+#!/bin/bash
+##############################################################################
+# Copyright (c) 2015 Huawei Technologies Co.,Ltd and others.
+#
+# All rights reserved. This program and the accompanying materials
+# are made available under the terms of the Apache License, Version 2.0
+# which accompanies this distribution, and is available at
+# http://www.apache.org/licenses/LICENSE-2.0
+##############################################################################
+
+cd /bottlenecks/rubbos/rubbos_scripts/1-1-1
+source set_bottlenecks_rubbos_env.sh
+
+echo "RESETING MYSQL on $HOSTNAME"
+# copy rubbos data files
+#tar xzf $RUBBOS_TOP/$RUBBOS_DATA_TARBALL --directory=$MYSQL_HOME/data/rubbos
+cd $MYSQL_HOME
+bin/mysqld_safe&
+sleep 10
+/etc/init.d/mysql.server status
+
+echo "BEGIN RUBBOS DATABASE GIVE PRIVILEGES"
+cat << EOF | mysql -uroot
+
+DROP DATABASE IF EXISTS rubbos;
+
+CREATE DATABASE rubbos;
+
+GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'%' \
+    IDENTIFIED BY 'rubbos';
+    flush privileges;
+GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'localhost' \
+    IDENTIFIED BY 'rubbos';
+    flush privileges;
+EOF
+echo "END RUBBOS DATABASE GIVE PRIVILEGES"
+
+echo "BEGIN IMPORT SQL DATA $(date)"
+echo "software_home=$SOFTWARE_HOME"
+tar xzf $SOFTWARE_HOME/$RUBBOS_DATA_TARBALL --directory /tmp
+mysql -uroot rubbos < /tmp/$RUBBOS_DATA_SQL
+echo "END IMPORT SQL DATA $(date)"
+rm /tmp/$RUBBOS_DATA_SQL
+
+bin/mysqladmin shutdown
+
+echo "DONE RESETING MYSQL on $HOSTNAME"
+sleep 5 
+
-- 
cgit 1.2.3-korg