Automating Backups of Your MySQL Databases via Minimal Mysqldump Privileges
Now that MySQL is set up and configured on OS X Server, here’s how to ensure that databases are regularly backed up — while granting to the backup script only the minimal privileges needed for mysqldump.