Published 2002-05-03 21:48:00
|
#!/bin/sh #// dumping section of backup.. # DATE = 2001_jan_monday DATEM = 2001_jan #rotated files DATE=`/bin/date +%Y_%B_%A` DATEM=`/bin/date +%Y_%B` # dump databases! - Midgard, rm /var/backup/midgard_$DATE.sql.gz /usr/bin/mysqldump --opt -uroot -pxxxxxxx midgard > /var/backup/midgard_$DATE.sql /bin/gzip /var/backup/midgard_$DATE.sql # Sitegroup databases rm /var/backup/mgd_6b080197635b37e72ff2c257abf0b957_$DATE.sql.gz /usr/bin/mysqldump --opt -uroot -pxxxxxxx mgd_6b080197635b37e72ff2c257abf0b957 > /var/backup/mgd_6b080197635b37e72ff2c257abf0b957_$DATE.sql /bin/gzip /var/backup/mgd_6b080197635b37e72ff2c257abf0b957_$DATE.sql rm /var/backup/mgd_e734103d46be96da3213acd005cf4bf1_$DATE.sql.gz /usr/bin/mysqldump --opt -uroot -pxxxxxxx mgd_e734103d46be96da3213acd005cf4bf1 > /var/backup/mgd_e734103d46be96da3213acd005cf4bf1_$DATE.sql /bin/gzip /var/backup/mgd_e734103d46be96da3213acd005cf4bf1_$DATE.sql #mysql's database - so all the passwords work! rm /var/backup/mysql_$DATE.sql.gz /usr/bin/mysqldump --opt -uroot -pxxxxxxx mysql > /var/backup/mysql_$DATE.sql /bin/gzip /var/backup/mysql_$DATE.sql # tar up web data (fimages and blobs etc.) /bin/tar cvzf /var/backup/var_www_$DATEM.tgz /var/www/ #// transfer it somewhere!!! /usr/bin/rsync -vvvv -a -e /usr/bin/ssh /var/backup/* alan@mybackupserver.com:/home/alan/akbkhome_backup/ |
