Drush + Bash + Cron: Datbase Backup Goals

• Scan sites directory for a given drupal install
• Find all multisite folders/symlinks
• For each multisite:
• Use Drush to clear cache - we dont want cache table bloating up the MySQL dump file
• Use Drush to delete watchdog logs - we dont want watchdog table bloating up the MySQL dump file
• Use Drush to backup the database to pre-assigned folder
• Use tar to compress and timestamp the Drush generated sql file

read more