This is the use of magento2 scheduled tasks perform their own shell command to back up the database operation.
Please enter your magento2 root directory, execute the following command:
First add repository to composer configuration:
composer config repositories.michaeldyl520-magento2-mysql-backup-with-cron vcs git@github.com:michaeldyl520/magento2-mysql-backup-with-cron.git
Require new package with composer:
composer require michaeldyl520/magento2-mysql-backup-with-cron
Enable module:
php bin/magento module:enalbe Jiliuke_Backup
Maybe you need run:
php bin/magento setup:upgrade && php bin/magento cache:clean