You can use this file to cron backup of MySQL databases in Year > Month > Day structured directory.
- First copy the file
mysql-backup.shinto your server. - Change the
USER,PASSWORDor other options from the file and save it. - Change the file permission
sudo chmod +x mysql-backup.sh - Now use
crontab -eto set your cron job. If you are not sure what iscrontabthen search it on google.