Backuplösung für Rootserver: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 30: | Line 30: | ||
=Teil 2: Verschlüsselung= | =Teil 2: Verschlüsselung= | ||
{{Box File|backup-mysql.sh| | |||
- | <pre> | ||
#!/bin/bash | |||
date=`date -I` | |||
# configuration variables | |||
USERNAME="backupuser" | |||
PASSWORD="password" | |||
DBHOST="localhost" | |||
BACKUPDIR="/root/backups" | |||
# encryption variables | |||
PGPMAILUSERPUB="a.backup.user@deltaquadrant.org" | |||
OPTS="--opt --allow-keywords --flush-logs --hex-blob --master-data --max_allowed_packet=16M --quote-names" | |||
OPTS_FULLBACKUP="--all-databases --opt --allow-keywords --flush-logs --hex-blob --master-data --max_allowed_packet=16M --quote-names" | |||
# backup each database into an individual file | |||
DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST --batch --skip-column-names -e "show databases"| sed 's/ /%/g'`" | |||
for i in $DBNAMES | |||
do | |||
mysqldump $i --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPTS | bzip2 -c | \ | |||
gpg --armor --encrypt --trust-model always --recipient $PGPMAILUSERPUB - > $BACKUPDIR/$i-$date.SQL.bz2.gpg | |||
done | |||
# backup all databases into one big file | |||
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPTS_FULLBACKUP | bzip2 -c | \ | |||
gpg --armor --encrypt --trust-model always --recipient $PGPMAILUSERPUB - > $BACKUPDIR/FULLBACKUP-MYSQL-ALL-$date.SQL.bz2.pgp | |||
</pre> | |||
}} | |||
=Teil 3: Dateiübertragung= | =Teil 3: Dateiübertragung= | ||
work in progress | work in progress | ||
- scponly & keyauth | - scponly & keyauth | ||
Revision as of 23:09, 6 June 2006
Teil 1: MYSQL Backup erstellen
Teil 2: Verschlüsselung
Teil 3: Dateiübertragung
work in progress - scponly & keyauth