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