In my MySQL installation, I receive an error when it is executed (line 1568):
CHECK_TARGET_DB=$(mysql -h "$TARGET_DB_HOST" -P "$TARGET_DB_PORT" -u "$TARGET_DB_USER" -p"$TARGET_DB_PASS" -e "USE \"${TARGET_DB_NAME}\";" 2>&1)
I receive:
Checking target DB...mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"my-db"' at line 1
The problem seems to be the use of " in USE \"${TARGET_DB_NAME}\";. Removing them works without any problems:
CHECK_TARGET_DB=$(/Applications/MAMP/Library/bin/mysql -h "$TARGET_DB_HOST" -P "$TARGET_DB_PORT" -u "$TARGET_DB_USER" -p"$TARGET_DB_PASS" -e "USE ${TARGET_DB_NAME};" 2>&1)
In my MySQL installation, I receive an error when it is executed (line 1568):
I receive:
The problem seems to be the use of
"inUSE \"${TARGET_DB_NAME}\";. Removing them works without any problems: