Backup Restore Drill

[jdimatteo]

Have Charles pick an arbitrary file or database table, and then I should verify that I can restore the file/table to another machine.

To prepare for this, I should document the restore process for mysql tables.

We might want to verify that someone other than me knows how to restore files as well.

Lets plan on doing this after the offsite backups are working too.

[jdimatteo]

Testing out a restore of the meta_analysis mysql db backup to my laptop (which will help me do offline data analysis):

jdm@tod:/crusader/backup/automysqlbackup/daily$ ls -l meta_analysis/meta_analysis_2013-11-07_03h01m.Thursday.sql.gz
-rw------- 1 nobody nogroup 29863398 Nov  7 03:01 meta_analysis/meta_analysis_2013-11-07_03h01m.Thursday.sql.gz
jdm@tod:/crusader/backup/automysqlbackup/daily$ sudo scp meta_analysis/meta_analysis_2013-11-07_03h01m.Thursday.sql.gz [email protected]:/Users/jdimatteo/DanaFarber/copied_from_tod/

jd-mba:copied_from_tod jdimatteo$ gunzip meta_analysis_2013-11-07_03h01m.Thursday.sql.gz
jd-mba:copied_from_tod jdimatteo$ mysql -uroot meta_analysis < meta_analysis_2013-11-07_03h01m.Thursday.sql
jd-mba:copied_from_tod jdimatteo$

Note that I had to use sudo to copy the backup, since my jdm user doesn't have read access to the backup (which is a good thing). The loading of this backup through my took about a minute.

I documented this restore process: https://github.com/BradnerLab/SystemAdmin/wiki#backups