Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- USER="root"
- PASSWORD=""
- OUTDIR="`basename $1`"
- if [ -z "$OUTDIR" ]; then
- echo "Specify an output directory"
- exit 1;
- fi
- read -s -p "Password: " PASSWORD
- echo "Ok"
- if [ -z "$PASSWORD" ]; then
- echo "Specify a pasword."
- exit 2;
- fi
- databases=`mysql -u $USER -p$PASSWORD -s --skip-column-names -e "SHOW DATABASES;" | grep -Ev '(mysql|information_schema)'`
- for db in $databases; do
- filename="$db--`date +%Y%m%d`"
- echo "Dumping database: $filename"
- mysqldump -u $USER -p$PASSWORD --databases $db | gzip > "${OUTDIR}/${filename}.sql.gz"
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement