This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
build:backups [2007/06/13 15:39] 206.197.251.70 MySQL backup script. (CMB) |
build:backups [2010/07/18 16:51] (current) SLUUG Administration |
||
---|---|---|---|
Line 4: | Line 4: | ||
We're also backing up locally to tarballs for easier access, and to have multiple versions of backups. | We're also backing up locally to tarballs for easier access, and to have multiple versions of backups. | ||
+ | |||
===== Backup Dirs ===== | ===== Backup Dirs ===== | ||
Line 10: | Line 11: | ||
<code rootshell> | <code rootshell> | ||
mkdir -p /var/backups | mkdir -p /var/backups | ||
+ | mkdir -p /var/backups/bud | ||
+ | mkdir -p /var/backups/budlight | ||
mkdir -p /var/backups/etc | mkdir -p /var/backups/etc | ||
mkdir -p /var/backups/home | mkdir -p /var/backups/home | ||
Line 21: | Line 24: | ||
===== Rsync Backups ===== | ===== Rsync Backups ===== | ||
+ | |||
+ | For the procedure used for backups of michelob and dark using rsync, see [[rsync-aix]]. | ||
===== Tarball Backups ===== | ===== Tarball Backups ===== | ||
Line 85: | Line 90: | ||
Run the script to test that it works, and saves a file with the correct name in /var/backups/usr_local/. Run 'tar tfz' on the resulting backup file to make sure it contains the expected files. | Run the script to test that it works, and saves a file with the correct name in /var/backups/usr_local/. Run 'tar tfz' on the resulting backup file to make sure it contains the expected files. | ||
+ | |||
Line 91: | Line 97: | ||
NOTE: We currently store web sites in ''/home/web'', so we do not need to back up anything separately at this point. | NOTE: We currently store web sites in ''/home/web'', so we do not need to back up anything separately at this point. | ||
+ | We do have a backup procedure for the wiki content. The ''/etc/cron.daily/backup-dokuwiki'' script copies a backup of the wiki data files to ''/var/backups/web/''. | ||
+ | |||
+ | <code /etc/cron.daily/backup-dokuwiki> | ||
+ | #!/bin/sh | ||
+ | |||
+ | DATE=`date +'%Y%m%d'` | ||
+ | BACKUPDIR=/var/backups/web | ||
+ | EXCLUDE='data/cache/*' | ||
+ | INCLUDE='data/ conf/' | ||
+ | WIKIDIR=/srv/www/wiki.sluug.org/public | ||
+ | |||
+ | tar cfz $BACKUPDIR/wikidata-$DATE.tgz -C $WIKIDIR --exclude="$EXCLUDE" $INCLUDE | ||
+ | |||
+ | </code> | ||
+ | |||
+ | This tars all other vhosts in /srv/www | ||
+ | |||
+ | <code /etc/cron.daily/backup-www> | ||
+ | #!/bin/sh | ||
+ | |||
+ | SRCDIR=/srv/www | ||
+ | BACKUPDIR=/var/backups/web | ||
+ | EXCLUDE='wiki.sluug.org/* wordpress*' | ||
+ | DATE=`date +'%Y%m%d'` | ||
+ | |||
+ | tar cfz $BACKUPDIR/www-$DATE.tgz -P $SRCDIR --exclude="$EXCLUDE" | ||
+ | </code> | ||
==== Backup of Email ==== | ==== Backup of Email ==== | ||
Line 124: | Line 157: | ||
Take a look at [[http://jeremy.zawodny.com/mysql/ | mysqlsnapshot]] to see if it might work better for MySQL backups. Note that it has not been updated for MySQL 4.x or 5.x, but it's a Perl script, so it might still work. | Take a look at [[http://jeremy.zawodny.com/mysql/ | mysqlsnapshot]] to see if it might work better for MySQL backups. Note that it has not been updated for MySQL 4.x or 5.x, but it's a Perl script, so it might still work. | ||
- |