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