USER is a username on your Linux system. Save and close the crontab file. Now, your MySQL database will be backed up every day at 1 a.m. into the /home/USER directory. How to restore your database ...

It can be the same plist, just a matter of where you put it (/Library/LaunchDaemons vs /Library/LaunchAgents). Also, if you want to keep multiple copies of the back up, you could do something like ...

If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and restore your MySQL/MariaDB databases with one of the easiest tools on the market.