Can't get crontab working for mysql backups

[GreenZone]

I've got mysql and Xenforo running inside of Docker containers, with mapped volumes to the main virtual private server (VPS).

I'm having issues in trying to use crontab in order to schedule daily database dumps from mysql.

If I'm on the main VPS, I can successfully manually run this command in order to run a shell script inside of the mySQL Docker container in order to do the backup:

/usr/bin/docker exec -ti mysql sh -c "/var/lib/mysql/backups/xenforo_mysql_backup.sh"

If I place that same command into my crontab on the VPS, I can confirm via the system log (/var/log/syslog) that crontab is trying to initiate the command, but the command ends up not running.

The shell script being called inside of the Docker container has this within it:

/usr/bin/mysqldump --opt -uMyUser -pMyPassword xenforo > /var/lib/mysql/backups/xenforo_backup_$(/bin/date +%Y-%m-%d).sql

I'll include two screenshots with step by step demos of what's going on.

Any ideas?

 

[Tracy Perry]

You may not get much response in this area... it probably should have gone into the Server Configuration & Hosting area.

 

[truonglv]

Try:

docker exec mysql sh -c "sh /var/lib/mysql/backups/xenforo_mysql_backup.sh"

 

[GreenZone]

@truonglv , I gave that a try.

The crontab did kick off the command, but as before it didn't result in actually kicking off the sql dump.
See the "backup3.png" attachment.

If I run the command manually, it does work fine, also as in my prior examples.
See the "backup4.png" attachment.

 

[GreenZone]

@truonglv , looks like your suggestion was correct and I misread your command.

I needed to remove the "-it" option, which I now realize that you had stated in your reply.
This was also confirmed here.

Thanks for your help.