备份

#!/bin/bash

USER="root"
PASSWORD=""

mkdir MySQL_Backup_`date +%Y%m%d`

# for i in `mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
for i in `mysql -B -N -e "show databases" -u${USER} -p${PASSWORD}|xargs`
do
if [ $i != "information_schema" ] && [ "$i" != "sys" ] && [ "$i" != "performance_schema" ] && [ "$i" != _* ]
then
echo "Dumping database: $i"
mysqldump -u${USER} -p${PASSWORD} ${i} > MySQL_Backup_`date +%Y%m%d`/${i}.sql
fi
done

zip -r MySQL_Backup_`date +%Y%m%d`.zip MySQL_Backup_`date +%Y%m%d`
rm -rf MySQL_Backup_`date +%Y%m%d`