スクリプトから起動するとmysqldumpが失敗する

端末で次のコマンドを実行すると、期待どおりに機能します。

/var/www$ sudo mysqldump --defaults-extra-file=/mnt/./.sql/mysqldump.cnf --databases site3 --hex-blob | sudo tee /mnt/site3/20230404_site3.sql

スクリプトで同じコマンドを実行します。

-rwx------ 1 root root 1686 apr  4 22:23 BackupDrupal.sh
/var/www$ sudo ./BackupDrupal.sh site3

次のメッセージで終わります。

/*!40000 ALTER TABLE `watchdog` ENABLE KEYS */;
UNLOCK TABLES;
mysqldump: Got error: 1049: Unknown database '|' when selecting the database

スクリプト：

#!/bin/bash  
#SCRIPT FOR BACKING UP THE DRUPAL FOLDER AND THE DRUPAL DATABASE
#the mysqldump and the whole drupal directory are placed on the  mounted /dev/sda11 parition

#For backing up site3 the script is launched like:
#$ sudo ./Backup_Drupal.sh site3


#define variables
NOW=$(date +"%Y%m%d")
TARGET_DIR="/mnt/$1"
TARGET_FILE=$TARGET_DIR"/"$NOW"_"$1".sql"
SOURCE_DIR="/var/www/"$1
RET=$(mount | grep "/dev/sda11")
ARR=( $RET ) 
#echo $NOW
#echo $TARGET_DIR
#echo $TARGET_FILE
#echo $SOURCE_DIR
#echo $RET
#echo ${ARR[0]}

#check if mounted / if not: mount /dev/sda11
if [ -z "$ARR" ] 
    then 
        echo -e "ARR is empty - /dev/sda11 not mounted ...\n"
        echo -e "Mounting now ... \n"
        mount -t ext4 /dev/sda11 /mnt
fi

#Look for 1st argument
if [ -z "$1" ] 
    then
        echo -e "An argument is needed to run this script. Launch like Backup_Drupal site99 ...\n"
                exit 1  
fi

#check path
if [ -d "$TARGET_DIR" ];
    then
            echo -e "Installing backup in  ${TARGET_DIR} ...\n"
else
        echo -e "Directory ${TARGET_DIR} does not exist ...\n"
            exit 1
fi

#mysqldump database
echo -e "Saving database ...\n"
#SQLDUMP="sudo mysqldump -u root -p --databases $1 --hex-blob | sudo tee $TARGET_FILE;"
SQLDUMP="sudo mysqldump --defaults-extra-file=/mnt/./.sql/mysqldump.cnf --databases $1 --hex-blob | sudo tee $TARGET_FILE"
$SQLDUMP
echo -e "the command used = $SQLDUMP \n"
echo -e "Database saved as $TARGET_FILE...\n"

#save drupal folder in tar.gz format
echo -e "Saving $1 folder in tar.gz format...\n"
TARGET_FILE=$TARGET_DIR"/"$NOW"_"$1".tar.gz"
tar -cpzf $TARGET_FILE $SOURCE_DIR
echo -e "$SOURCE_DIR saved as $TARGET_FILE...\n"
echo -e "All done...\n"

[参照:][1][1]: https://unix.stackexchange.com/questions/741683/permission-denied-using-mounting-point-redirection-in-mysqldump