mysql数据库分表备份脚本_mysql分表备份和分库备份shell脚本

mysql分表备份和分库备份shell脚本

`#!/bin/bash

my_user='root' my_pwd='root'

date_today=$(date +%Y-%m-%d) backup_dir='/data/backup/'

function dump { dump_file=$db-$tb-$date_today'.sql' mysqldump --user=$my_usr --password=$my_pwd --lock-tables --databases $db --tables $tb > $backup_dir$dump_file }

list=mysql --user=$my_usr --password=$my_pwd -e "show databases"| sed '1d'

for db in $list do if [ $db != 'mysql' ] && [ $db != 'information_schema' ] && [ $db != 'performance_schema' ] then arry=mysql $db --user=$my_usr --password=$my_pwd -e "show tables;" | sed '1d' for tb in $arry do

dump

sleep 1

echo $db.$tb is backup

done

fi done `