diff options
Diffstat (limited to 'rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh')
-rwxr-xr-x | rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh | 32 |
1 files changed, 31 insertions, 1 deletions
diff --git a/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh b/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh index 551c9d7f..aac9cc01 100755 --- a/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh +++ b/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_reset.sh @@ -5,7 +5,37 @@ 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 +#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 + |