My site is controlled via cpanel. I want to automate the backup of my databases and then automate their download to my development machine. The first step was to set up the cron jobs as follows
0 3 * * 4 mysqldump -u username -p password database1 > backup/db_biz_directory.sql
0 4 * * 4 mysqldump -u username -p password database2 > backup/db_swr_software.sql
- There are two empty files in the backup folder timestamped 11th, that is last Thursday.
- There are no errors in the errors section of cPanel.
- There is nothing under etc, logs or var folders.
- I did not receive any emails, they are set up and do work.
- There are tables and data in those databases.
Since the files exist, the jobs obviously ran. What is wrong with my job? Could the errors be logged somewhere else?