#!/bin/sh
USER=root
PASSWD=oldboy
SOCKET=/data/3306/mysql.sock
LOGIN="mysql -u$USER -p$PASSWD -S $SOCKET"
DATABASE=$($LOGIN -e "show databases;"|egrep -v "*chema|mysql"|sed ‘1d‘)
DUMP="mysqldump -u$USER -p$PASSWD -S $SOCKET"
for database in $DATABASE
do
TABLE=$($LOGIN -e "use $database;show tables;"|sed ‘1d‘)
for table in $TABLE
do
[ -d /server/backup/$database ] || mkdir -p /server/backup/$database
# [ ! -d /server/backup/$database ] && mkdir -p /server/backup/$database
$DUMP $database $table |gzip >/server/backup/$database/${database}_${table}_$(date +%F).sql.gz
done
done
=============================================================
16、MySQL数据库分库分表备份脚本
标签：mysql数据库分库分表备份脚本