2 ##############################################################################
3 # Copyright (c) 2015 Huawei Technologies Co.,Ltd and others.
5 # All rights reserved. This program and the accompanying materials
6 # are made available under the terms of the Apache License, Version 2.0
7 # which accompanies this distribution, and is available at
8 # http://www.apache.org/licenses/LICENSE-2.0
9 ##############################################################################
11 cd /bottlenecks/rubbos/rubbos_scripts/1-1-1
12 source set_bottlenecks_rubbos_env.sh
14 echo "RESETING MYSQL on $HOSTNAME"
15 # copy rubbos data files
16 #tar xzf $RUBBOS_TOP/$RUBBOS_DATA_TARBALL --directory=$MYSQL_HOME/data/rubbos
20 /etc/init.d/mysql.server status
22 echo "BEGIN RUBBOS DATABASE GIVE PRIVILEGES"
23 cat << EOF | mysql -uroot
25 DROP DATABASE IF EXISTS rubbos;
27 CREATE DATABASE rubbos;
29 GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'%' \
30 IDENTIFIED BY 'rubbos';
32 GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'localhost' \
33 IDENTIFIED BY 'rubbos';
36 echo "END RUBBOS DATABASE GIVE PRIVILEGES"
38 echo "BEGIN IMPORT SQL DATA $(date)"
39 echo "software_home=$SOFTWARE_HOME"
40 tar xzf $SOFTWARE_HOME/$RUBBOS_DATA_TARBALL --directory /tmp
41 mysql -uroot rubbos < /tmp/$RUBBOS_DATA_SQL
42 echo "END IMPORT SQL DATA $(date)"
43 rm /tmp/$RUBBOS_DATA_SQL
45 bin/mysqladmin shutdown
47 echo "DONE RESETING MYSQL on $HOSTNAME"