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

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

Reference:

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