3 cd /bottlenecks/rubbos/rubbos_scripts/1-1-1
4 source set_bottlenecks_rubbos_env.sh
6 echo "RESETING MYSQL on $HOSTNAME"
7 # copy rubbos data files
8 #tar xzf $RUBBOS_TOP/$RUBBOS_DATA_TARBALL --directory=$MYSQL_HOME/data/rubbos
12 /etc/init.d/mysql.server status
14 echo "BEGIN RUBBOS DATABASE GIVE PRIVILEGES"
15 cat << EOF | mysql -uroot
17 DROP DATABASE IF EXISTS rubbos;
19 CREATE DATABASE rubbos;
21 GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'%' \
22 IDENTIFIED BY 'rubbos';
24 GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'localhost' \
25 IDENTIFIED BY 'rubbos';
28 echo "END RUBBOS DATABASE GIVE PRIVILEGES"
30 echo "BEGIN IMPORT SQL DATA $(date)"
31 echo "software_home=$SOFTWARE_HOME"
32 tar xzf $SOFTWARE_HOME/$RUBBOS_DATA_TARBALL --directory /tmp
33 mysql -uroot rubbos < /tmp/$RUBBOS_DATA_SQL
34 echo "END IMPORT SQL DATA $(date)"
35 rm /tmp/$RUBBOS_DATA_SQL
37 bin/mysqladmin shutdown
39 echo "DONE RESETING MYSQL on $HOSTNAME"