Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DBLIST=`mysql -uUNAME -pPSWD -ANe"SELECT GROUP_CONCAT(schema_name) FROM information_schema.schemata WHERE schema_name NOT IN ('information_schema','performance_schema')" | sed 's/,/ /g'`
- MYSQLDUMP_OPTIONS="-uUNAME -pPSWD --single-transaction --routines --triggers"
- BACKUP_DEST="/home/backup/db"
- for DB in `echo "${DBLIST}"`
- do
- mysqldump ${MYSQLDUMP_OPTIONS} ${DB} | gzip --stdout | s3cmd --reduced-redundancy put - s3://BUCKET/`date +\%G-\%m-\%d`_db-${DB}.sql.gz --no-encrypt
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement