#!/bin/bash
# Backup all databases in a MySQL or MariaDB server.

password="$1"

if [ -z $password ]; then
	echo "Usage: $0 MYSQL_ROOT_PASSWORD" 1>&2
	exit 1
fi

for i in $(mysql -u root -p${password} -e "show databases;" | grep -E '\w' | tail -n +2); do
	if [[ $i != "information_schema" ]]; then
		echo "Doing backup for database $i..."
		mysqldump -u root -p${password} $i > $i.sql
	fi
done