Created by Oleksiy Kalinichenko 2017-05-04

File mysql-export-all-databases.sh Added

+#!/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

Snippets