备份除了系统库以外的所有数据库

    1. #!/bin/bash
    2. user=root
    3. password=123456
    4. host=127.0.0.1
    5. data_path=/tmp
    6. mysql -e "show databases;" -u $user -p $password -h $host| grep -Ev "Database|information_schema|performance_schema|mysql|sys"|xargs mysqldump -uroot -p$password --set-gtid-purged=OFF --triggers --routines --events --single-transaction --flush-logs --master-data=2 --databases > $data_path/all.sql