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 [email protected]: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 [email protected]: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]