Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # change these
- bucket="s3://bucketname"
- backupdir="/var/www/vhosts/domain.com/backup"
- dbuser="dbuser"
- dbpass="dbpass"
- dbname="db"
- cd ~pmpro/backup/
- mysqldump -u$dbuser -p$dbpass $dbname > $dbname_`date +'%Y-%m-%d'`.sql
- gzip $dbname_`date +'%Y-%m-%d'`.sql
- s3cmd put $dbname_`date +'%Y-%m-%d'`.sql.gz "$bucket/$dbname_`date +'%Y-%m-%d'`.sql.gz"
- mv $dbname_`date +'%Y-%m-%d'`.sql.gz $backupdir/old
Add Comment
Please, Sign In to add comment