linux中mysql备份所有数据库的Shell脚本

#!/bin/bash
 
DATE=$(date +'%Y%m%d')
TO_DIR="/home/wyl/文档/日报/230_database"
DATE_DIR=${TO_DIR}"/"${DATE}
 
HOSTNAME='192.168.1.230'
USERNAME='root'
PASSWORD='tianji'
 
if [ ! -d "$DATE_DIR" ]; then
        mkdir $DATE_DIR
fi
mysqldump --no-data -h$HOSTNAME -u$USERNAME -p$PASSWORD --all-databases > $DATE_DIR/all_database.sql

#!/bin/bash
  
DATE=$(date +'%Y%m%d')
TO_DIR="/home/wyl/文档/日报/230_database"
DATE_DIR=${TO_DIR}"/"${DATE}
  
HOSTNAME='192.168.1.230'
USERNAME='root'
PASSWORD='tianji'
  
if [ ! -d "$DATE_DIR" ]; then
        mkdir $DATE_DIR
fi
mysql -h$HOSTNAME -u$USERNAME -p$PASSWORD -e "show databases like '%9e%'"|sed '1d'|while read LINE
do
        mysqldump --no-data -h$HOSTNAME -u$USERNAME -p$PASSWORD $LINE > $DATE_DIR/$LINE.sql
done