diff options
author | 2016-04-13 15:57:00 +0800 | |
---|---|---|
committer | 2016-04-13 15:59:19 +0800 | |
commit | dd7eae17aca39d609e28afd5fadf110c5e1e769e (patch) | |
tree | 6a7547da23bebe9db2bc68d5dee32b2d3030b842 /testsuites/rubbos/puppet_manifests/modules/rubbos_mysql/files/prepare_rubbos_mysql_db.sh | |
parent | bdd42e03b0e8ce99888d8ead6a622113af6d2ab5 (diff) |
add a script for loading data into mysql database
JIRA: BOTTLENECK-54
Change-Id: Iad7c56b67618fbf2a21b3872735e692c08e53175
Signed-off-by: wangyaoguang <sunshine.wang@huawei.com>
Diffstat (limited to 'testsuites/rubbos/puppet_manifests/modules/rubbos_mysql/files/prepare_rubbos_mysql_db.sh')
-rwxr-xr-x | testsuites/rubbos/puppet_manifests/modules/rubbos_mysql/files/prepare_rubbos_mysql_db.sh | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/testsuites/rubbos/puppet_manifests/modules/rubbos_mysql/files/prepare_rubbos_mysql_db.sh b/testsuites/rubbos/puppet_manifests/modules/rubbos_mysql/files/prepare_rubbos_mysql_db.sh new file mode 100755 index 00000000..ee073684 --- /dev/null +++ b/testsuites/rubbos/puppet_manifests/modules/rubbos_mysql/files/prepare_rubbos_mysql_db.sh @@ -0,0 +1,49 @@ +#!/bin/bash +############################################################################# +# Copyright (c) 2016 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 +############################################################################## + + +## Usage: prepare_rubbos_mysql_db.sh rubbos_data_sql.tar.gz rubbos_data_sql_dir +## It is used for loading data into mysql database. +if [ ! -d '/usr/local/mysql' ] || [ $# -ne 2 ] || [ ! -f $1 ];then + echo "It requires: Mysql is installed, two arguments, and the second points to a data_sql file." + exit 1; +fi + +rubbos_mysql_db_compressed_file=$1 +rubbos_mysql_db_uncompressed_dir=$2 + +# clear database +echo "BEGIN RUBBOS DATABASE GIVE PRIVILEGES" +cat << EOF | /usr/local/mysql/bin/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" + +# import sql data +echo "BEGIN IMPORT SQL DATA" +if [ -d '${rubbos_mysql_db_uncompressed_dir}' ]; then + rm -rf ${rubbos_mysql_db_uncompressed_dir} +fi +mkdir -p ${rubbos_mysql_db_uncompressed_dir} +tar zxvf ${rubbos_mysql_db_compressed_file} --directory ${rubbos_mysql_db_uncompressed_dir} +/usr/local/mysql/bin/mysql -uroot rubbos < ${rubbos_mysql_db_uncompressed_dir}/rubbos_data_sql +echo "END IMPORT SQL DATA" + +rm -rf ${rubbos_mysql_db_uncompressed_dir} |