Creating additional database backups

Issue

I want to create additional database backups on a more frequent basis.

Resolution

A Warning Note

This method will cause additional database backups, which can fill up your storage if not pruned on a regular basis.

This can be accomplished and scheduled by following these steps:

1. Craft a command using drush sql-dump and confirm it works.
   
   Example command:
   copy

   drush @sitename.environment sql-dump > /mnt/gfs/${AH_SITE_NAME}/backups/on-demand/$(date +"%Y-%m-%d-%H%M%S").sql

    

2. This takes a database backup every 4 hours and outputs to your on-demand directory in /mnt/gfs.

3. Add to Scheduled Jobs