#!/bin/bash

# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

#
# Script to reset mysql database
#

#if [ $# -lt 1 ]; then
#       echo "Usage: $0 <db_root_password> [db_host] <db_name>"
#       exit 1
#fi
#
#db_root_password=$1
#db_host="localhost"
#if [ "$2" != "" ]; then
#    db_host="$2"
#fi
#db_name="xa_db"
#if [ "$3" != "" ]; then
#    db_name="$3"
#fi

db_user=xaadmin
db_password=xaadmin
db_file=xa_core_db.sql
db_name=xa_db

echo "Importing database file $db_file.sql ...  "
set -x
mysql -u $db_user  --password=$db_password --database=$db_name < $db_file