MySQL分表自动备份脚本
#!/bin/bash
DB_LIST=$(mysql -uroot -s -e "show databases;" | grep -v "Database")
DB_DIR=msyql_backup_`date +%F`
[ ! -d $DB_DIR ] && mkdir $DB_DIR
for i in $DB_LIST
do
for j in `mysql -uroot -s -e "use $i;show tables;" | grep -v Tables_in_mysql`
do
mysqldump -uroot ${i} ${j} > ${DB_DIR}/${i}_${j}.sql 2>/dev/null
done
done