Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- HOSTNAME='localhost'
- MYSQLUSER='root'
- MYSQLPASS='xyz'
- for DB in $(mysql -h $HOSTNAME -u $MYSQLUSER --password=${MYSQLPASS} --batch --skip-column-names --execute="show databases");
- do
- local FILENAME=${HOSTNAME}_Database_${DB}.sql.gz.gpg
- mysqldump $DB -h $HOSTNAME -u $MYSQLUSER --password=${MYSQLPASS} --triggers --routines --event > $FILENAME
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement