create backup cronjob in cpanel
first script : to make backup cronjob using mysqldump console command : script to make backup mysqldump -h your_ip_address_or_domain -u database_username -p’yourpassword’ database_name > /home/stiepanc/public_html/database_backup/db-backup-$(/bin/date +\%d\%m\%Y).sql cron job to run automatic query