Created by
Oleksiy Kalinichenko
| #!/bin/bash
stty -echo
printf 'MySQL ROOT Password: ' >&2
read PASSWORD
stty echo
printf "\n"
if [ -z "$PASSWORD" ]; then
echo 'No password given!'
exit 1
fi
MYSQL_ACCESS=" -uroot -p${PASSWORD} "
databases=`mysql $MYSQL_ACCESS --batch --skip-column-names -e "SHOW DATABASES;" | grep -E -v "(information|performance)_schema"`
date=`date +%Y%m%d`
for db in $databases; do
echo "Dumping database: $db"
mysqldump $MYSQL_ACCESS --databases $db | gzip > mysqldump--$db--$date.sql.gz
done
|