Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2014
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.48 KB | None | 0 0
  1. 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'`
  2. MYSQLDUMP_OPTIONS="-uUNAME -pPSWD --single-transaction --routines --triggers"
  3. BACKUP_DEST="/home/backup/db"
  4. for DB in `echo "${DBLIST}"`
  5. do
  6.     mysqldump ${MYSQLDUMP_OPTIONS} ${DB} | gzip --stdout | s3cmd --reduced-redundancy put - s3://BUCKET/`date +\%G-\%m-\%d`_db-${DB}.sql.gz --no-encrypt
  7. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement