Full mysql dump

README.md

Скрипт архивирования всех таблиц указанного сервера mysql

Использование

git clone http://git.rg1.ru/artem/mysql_dump.git
cd ./mysql_dump
./main.sh -u USER -pPASS ...

main.sh

#!/bin/bash

cmd="mysqldump $*"

cmd_db_list="mysql $* -e 'SHOW DATABASES;'"

databases=`eval $cmd_db_list | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        dyn_cmd="$cmd --databases $db"
	cur_date=`date +%Y%m%d`
	file_name=$cur_date.$db.sql
        eval $dyn_cmd | tee $file_name
        #eval $dyn_cmd > date +%Y%m%d.$db.sql
       # gzip $OUTPUT/`date +%Y%m%d`.$db.sql
    fi
done