- May 10, 2021
I know I've seen the instructions for doing this around the internet over the past few years, but I completely forget how to do it or where the instructions were. My goal is to save backups (database dumps) of my website's MySQL database to my hosting account's home directory. I obviously don't want this file publicly accessible. Also, since the database can get over 50MB, I'd like to zip it, or compress it before it saves to the home directory. I would like to run a cron job once per day and have the new file overwrite the old one. Every so often, I'll FTP in to the home directory and download the database for safe keeping (backup). Can anyone please give me the directions for setting up a compressed MySQL database dump cron job in cPanel?