Guest User

Untitled

a guest
Mar 21st, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. # change these
  2. bucket="s3://bucketname"
  3. backupdir="/var/www/vhosts/domain.com/backup"
  4. dbuser="dbuser"
  5. dbpass="dbpass"
  6. dbname="db"
  7.  
  8. cd ~pmpro/backup/
  9. mysqldump -u$dbuser -p$dbpass $dbname > $dbname_`date +'%Y-%m-%d'`.sql
  10. gzip $dbname_`date +'%Y-%m-%d'`.sql
  11.  
  12. s3cmd put $dbname_`date +'%Y-%m-%d'`.sql.gz "$bucket/$dbname_`date +'%Y-%m-%d'`.sql.gz"
  13.  
  14. mv $dbname_`date +'%Y-%m-%d'`.sql.gz $backupdir/old
Add Comment
Please, Sign In to add comment