WordPress Site Backup Procedure

DATE: 2014-09-06

1. 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>

   * In SQL section set parameters ON:

     + Add DROP TABLE ...
     + Add IF NOT EXISTS
     + Add AUTO_INCREMENT value
     + Enclose table and field ...
     (Others OFF)

   * 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.

2. Backup site file system:

   * Change directory to installation parent.

   * tar czf <tmpdir>/bika-wp-files-<yyyymmdd>.tar.gz bika

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

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

Reference:

  - http://codex.wordpress.org/WordPress_Backups