blob: aac9cc01a3d82d70888d97b3b35c32242f55a4a6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
#!/bin/bash
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
|
