diff options
| -rw-r--r-- | components/datalake-handler/feeder/src/assembly/init_db/scripts/db_init/10_check-db-exist | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/components/datalake-handler/feeder/src/assembly/init_db/scripts/db_init/10_check-db-exist b/components/datalake-handler/feeder/src/assembly/init_db/scripts/db_init/10_check-db-exist index cdf8af50..4b2130a3 100644 --- a/components/datalake-handler/feeder/src/assembly/init_db/scripts/db_init/10_check-db-exist +++ b/components/datalake-handler/feeder/src/assembly/init_db/scripts/db_init/10_check-db-exist @@ -17,9 +17,10 @@ # limitations under the License. # ============LICENSE_END============================================ # -result=`mysql -qfsB -uroot -p$MYSQL_ROOT_PASSWORD -h $MYSQL_HOST -P $MYSQL_PORT -e "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='datalake'" 2>&1` -if [[ ! -z $result ]]; +result=`mysql -uroot -p$MYSQL_ROOT_PASSWORD -h $MYSQL_HOST -P $MYSQL_PORT -e "USE 'datalake'"` + +if [ $? == 0 ] ; then echo "DATABASE ALREADY EXISTS" touch /tmp/db_exist @@ -27,4 +28,4 @@ then else echo "DATABASE DOES NOT EXIST" exit 0 -fi
\ No newline at end of file +fi |