Docker. docker-compose. Run via cron. How?

Question

Docker

There is a server with a docker environment... everything works, everything is fine...

There is a container with MariaDB...

In cron I do two commands for testing:

*/5 * * * * cd /home/USER/ && /usr/local/bin/docker-compose -f prod-compose.yml exec mariadb /usr/bin/mysqldump -u USER -pPASSWORD --single-transaction DB_NAME | gzip > /home/USER/BACKUP/DB_$(date +%d-%m-%Y_%H_%M_%S).sql.tar.gz

*/5 * * * * touch /home/USER/BACKUP/test.txt

The first does NOT work ...
The second - all the rules.

At the same time, if you copy the first command and just run it in the console from under the same user, then everything works out the rules ...

Even I specifically blunted ... or the skis do not go ... :)

Answer 1

In general, I won ... It was in the -T
flag to the docker-compose exec command. Why read the documentation for this flag . As a result, the command is:

*/5 * * * * cd /home/USER/ && /usr/local/bin/docker-compose -f prod-compose.yml exec -T mariadb /usr/bin/mysqldump -u USER -pPASSWORD --single-transaction DB_NAME | gzip > /home/USER/BACKUP/DB.sql.tar.gz

PS: Passing through cd is required...otherwise it won't work...if the paths in compose.yml are relative everywhere...and usually they are...

Answer 2

1) look for errors when running from cron - in the mail if there is no redirect
2) try without a timestamp in the file name - I remember that there were some problems

Answer 3

Specify the full path to docker-compose

Answer 4

Maybe so

*/5 * * * *  /usr/local/bin/docker-compose -f /home/USER/prod-compose.yml exec mariadb /usr/bin/mysqldump -u USER -pPASSWORD --single-transaction DB_NAME | gzip > /home/USER/BACKUP/DB_$(date +%d-%m-%Y_%H_%M_%S).sql.tar.gz