blob: eea03bda643877429d57e134721eae2a12179308 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
#!/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
|
