diff options
| -rwxr-xr-x | bin/backup_mysql.sh | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/bin/backup_mysql.sh b/bin/backup_mysql.sh new file mode 100755 index 0000000..eea03bd --- /dev/null +++ b/bin/backup_mysql.sh @@ -0,0 +1,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 |