#!/bin/bash
set -e
set -x

#
# Copyright 2017 Goldman Sachs.
# Licensed 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.
#

CONTAINER_NAME=obevo-mysql-instance
INSTANCE_DBNAME="dbdeploy"
INSTANCE_SCHEMAS="dbdeploy01"
# note - this user ID is hardcoded by the container
INSTANCE_USERID=root
INSTANCE_PASSWORD=Deploybuilddb0!
echo $INSTANCE_PASSWORD

docker exec $CONTAINER_NAME /usr/bin/mysqldump -u $INSTANCE_USERID --password=$INSTANCE_PASSWORD --databases $INSTANCE_SCHEMAS --compact --compatible=ANSI --no-create-db --skip-quote-names --skip-dump-date --no-data --skip-add-drop-table > backup.sql
#docker exec $CONTAINER_NAME /usr/bin/mysqldump -u $INSTANCE_USERID --password=$PASSWORD --databases $INSTANCE_DBNAME --compact --compatible=ANSI --no-create-db --skip-quote-names --skip-dump-date > backup.sql

