Resolved unusual result when running cron job in Plesk

[mindzipper]

Server operating system version

Ubuntu 20.04.4 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.48

Could you clarify, please? I can write a simple command to do a MySQL dump, including the date variable, so the name is different, and it works fine.

I take that exact line and put it in the Plesk scheduled tasks adding a new task, and it fails.

When I used Webmin to do this, it worked fine.

Am I missing something?


Command:

mysqldump [FORUMNAME] > [BACKUPFILEPATH]backup-$(date "+%b-%d-%Y-%H-%M-%S").sql

P.S. yes, I know I'm outdated. I wanted to finish this first. I have been in the hospital for several months.

Failure results

/bin/sh: 1: Syntax error: Unterminated quoted string

 

[Kaspar]

You need to escape the % using a \ like \%.

 

[mindzipper]

You need to escape the % using a \ like \%.

I think I understand. I'm not a programmer/coder, so I'm winging it here.

You're saying I need to use

(date "+\%b-\%d-\%Y-\%H-\%M-\%S").sql

 

[mindzipper]

You need to escape the % using a \ like \%.

It worked. I sure appreciate that sir, thank you

successfully completed in 36 seconds.