1. #!/bin/bash
    2. DATE=$(date +%F_%H-%M-%S)
    3. HOST=localhost
    4. USER=backup
    5. PASS=123.com
    6. BACKUP_DIR=/data/db_backup
    7. DB_LIST=$(mysql -h$HOST -u$USER -p$PASS -s -e "show databases;" 2>/dev/null |egrep -v "Database|information_schema|mysql|performance_schema|sys")
    9. for DB in $DB_LIST; do
    10. BACKUP_DB_DIR=$BACKUP_DIR/${DB}_${DATE}
    11. [ ! -d $BACKUP_DB_DIR ] && mkdir -p $BACKUP_DB_DIR &>/dev/null
    12. TABLE_LIST=$(mysql -h$HOST -u$USER -p$PASS -s -e "use $DB;show tables;" 2>/dev/null)
    13. for TABLE in $TABLE_LIST; do
    14. BACKUP_NAME=$BACKUP_DB_DIR/${TABLE}.sql
    15. if ! mysqldump -h$HOST -u$USER -p$PASS $DB $TABLE > $BACKUP_NAME 2>/dev/null; then
    16. echo "$BACKUP_NAME 备份失败!"
    17. fi
    18. done
    19. done