Drupal Site Backup Procedure

DATE: 2014-02-01

For each site in a multi-site installation:

  1. Put site in maintenance mode.

  2. Back-up site DB

     * Open phpMyAdmin page

     * Log-in, select database "papa", click Export tab.

     * Export Method: Custom

     * Select tables by prefix (multiple prefixes can be backed-up
       together IF they have the same level of confidentiality and the
       same users)

     * File name template: <prefix>-db-<yyyymmdd>

     * Add DROP TABLE ...: ON

     * All other parameters: default

     * Compress SQL file with gzip.

     * Upload back-up file to directory papa@ma.sdf.org:backup

     * May delete local back-up file and older back-up files on MetaArray.

For each Drupal installation:

Back-up file system subtree for each Drupal installation:

  1. Change directory to installation parent.

  2. MOTD: tar czf <tmpdir>/motd-dp-files-<yyyymmdd>.tar.gz drupal
     MetaArray: tar czf ~/backup/ma-dp-files-<yyyymmdd>.tar.gz drupal

  3. For MOTD installation, upload back-up file to papa@ma.sdf.org:backup

  4. May delete local back-up and older back-ups on MetaArray.

Reference:

  - http://www.siteground.com/tutorials/drupal/drupal_backup.htm


[edited with|TECO]