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:

• 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

   

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

• Add to Scheduled Jobs