I want to schedule the run of a command that back's up my sql database that is running inside a docker container, so that I can back this up externally using duplicati. I found a command that works when I run it in a shell, using either sudo or logging in as root and running it, but the command throws an error when I run it as a scheduled job in OMV. Here is the command.
Code
docker exec -it zabbix-mysql /bin/bash -c 'mysqldump -u root -pmypassword zabbix > /var/lib/mysql/backups/zabbix.sql'
And here is the error the OMV throws when I try to run it as a scheduled job.
and the error details.
If no one can help me figure out what is causing the error and fix it, I am also willing to take suggestions on different ways to accomplish my goal of backing up the database.