Command problem

[eric85]

Hello,

I have defined command in script to detect Day, but it doesn't properly.

Here is script

cd /home/username/`date | awk '{print $1}'`;
/usr/bin/mysqldump --user=mysqluser --password=password --databases databasename database > database.sql

Output

root[~]#sh -x sql-backup-daily-new.sh
++ date
++ awk '{print $1}'
+ cd $'/home/username/Fri\r'
: No such file or directoryne 2: cd: /home/username/Fri

PS :: Folder /home/username/Fri is available on the system
Please help why script is taking day as 'Fri\r' instead of 'Fri'

[hazel]

Please help why script is taking day as 'Fri\r' instead of 'Fri'

The awk print command always ends its output with the output record separator (ORS). By default, this is newline. You have more control over your output if you use printf.

[Freston]

You may want to try `date +%a`

See `man date` for more options

[eric85]

Hello,

Thank you for the reply..

The awk print command always ends its output with the output record separator (ORS). By default, this is newline. You have more control over your output if you use printf.

Used printf but doesn't worked.
cat sql-backup-daily-new.sh
cd /home/username/`date | awk '{printf $1}'`;
/usr/bin/mysqldump --user=mysqluser --password=password --databases databasename database > database.sql

You may want to try `date +%a`

See `man date` for more options

date +%a is also not worked.
cd /home/holidayg/mysqlbackup/`date +%a`
/usr/bin/mysqldump --user=mysqluser --password=password --databases databasename database > database.sql

[Freston]

date +%a is also not worked.
cd /home/holidayg/mysqlbackup/`date +%a`
/usr/bin/mysqldump --user=mysqluser --password=password --databases databasename database > database.sql

Then what exactly didn't work?

When I try:

mkdir ~/test/`date +%a`
cd ~/test/`date +%a`
# and even further
echo haha>hihi
cat ~/test/`date +%a`/hihi
# it outputs 'haha'

It works

Can you change your code to:

if [ -d /home/holidayg/mysqlbackup/`date +%a` ] ; then
     /usr/bin/mysqldump \
          --user=mysqluser \
          --password=password \
          --databases databasename database > \
     /home/holidayg/mysqlbackup/`date +%a`/database.sql
else
     echo "Target directory /home/holidayg/mysqlbackup/`date +%a` does not exist"
fi

[eric85]

if [ -d /home/holidayg/mysqlbackup/`date +%a` ] ; then
/usr/bin/mysqldump \
--user=mysqluser \
--password=password \
--databases databasename database > \
/home/holidayg/mysqlbackup/`date +%a`/database.sql
else
echo "Target directory /home/holidayg/mysqlbackup/`date +%a` does not exist"
fi

Thank you for your help. it worked