Advertisement
Guest User

Untitled

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