Backup Process

From Oramosswiki

This is the process I use to backup my data.

The process backs up the following:

1. The Oramoss Wiki
2. The MySQL database, which covers Wiki and Wordpress
3. All datafiles from /u01 to /mirror_backup - local copy on different spindles
4. All datafiles from /u01 to /MEDIA/BACKUP - for offsite backup

The following steps are to be undertaken every week:

1. Make a change (even an innocuous one) to the Blog - something to look for later on VENICE, to ensure the process has worked.
2. Start PEDRO machine
3. On NORAH laptop, start Toad For MySQL (Freeware)
4. Using Toad, log on to oramoss.com
5. Take a SQL dump of the "wiki_oramoss_com" database. Backup to be called "E:\data\oramoss\wiki\DDMONYYYY.sql" and for Structure and Data as well. Leave default options.
6. Start VENICE VM machine
7. Transfer the SQL dump file from PRAGUE to VENICE using FileZilla. Copy the file to "/home/jeff/Download" on VENICE.
8. On VENICE, bring up a terminal and su to root.
9. cd to /home/jeff/Download
10. Drop the "wiki_oramoss_com" database from VENICE by issuing "mysqladmin -p drop wiki_oramoss_com". Password is root password.
11. Create a new "wiki_oramoss_com" database on VENICE by issuing "mysql -p < 06JAN2010.sql" - change the filename to suit, of course.
12. Run the MediaWiki from VENICE and check that the most recent change (from #1) is present
13. IF any files in the skin have changed, then copy GuMax.php and GuMax.deps.php from /skins on oramoss.com to VENICE and also the gumax directory.
14. Copy all files from /u01 to /mirror_backup using /u01/ backup_internal.sh
15. Copy all files from /u01 to /MEDIA/BACKUP using /u01/ backup_external.sh